Registered aircraft · 10,537

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N66WZBowing Vending Co Inc · Louisville, TNBuilt 1980 · S/N TJ-321 N66XBSai Flight Services Inc · Greer, SCS/N TC-773 N66XXSale Reported · Denton, TXSale reportedBuilt 1964 · S/N 320C0033 N67000Registration Pending · Johns Island, SCRegistration pendingS/N ME-283 N6700CKelly Aviation & Investigation LLC · Vail, AZBuilt 1980 · S/N ME-275 N6701RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1980 · S/N ME-281 N6701TAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1980 · S/N ME-285 N6701VHub City Aviation Academy LLC · Lubbock, TXBuilt 1979 · S/N ME-297 N6701XPlewa Gary M · Hays, NCBuilt 1960 · S/N 310-0001 N6702XFlight Time Builders Inc · Memphis, TNBuilt 1981 · S/N ME-287 N6704DScaled Composites LLC · Mojave, CABuilt 1980 · S/N ME-325 N6706YSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N ME-299 N6709XNeches Air Inc · Silsbee, TXBuilt 1960 · S/N 310-0009 N670AMyers Matthew D · Gilbert, AZS/N 34-33136 N670GCFrauenhoff Frank · Manhattan, NVBuilt 1973 · S/N TH-359 N670WBCt Cattle Co LLC · Wichita Falls, TXBuilt 1966 · S/N 30-1053 N6711GQuality Aviation Inc · Atlanta, GABuilt 1979 · S/N ME-311 N6711YAero Services Lc · Woods Cross, UTBuilt 1968 · S/N 27-4039 N6712AMcginnis Air LLC · Rising Star, TXBuilt 1980 · S/N ME-312 N6713XSkowbo Rock G · Winchester, VABuilt 1960 · S/N 3100013 N6715APacific Fleet Aviation LLC · Rochester, NYS/N 27-7954082 N6716XEberly Steven · Euless, TXS/N 310-0016 N6716YGot Wings LLC · Woodbury, NYBuilt 1968 · S/N 27-4046 N6716ZNextgen Flight Academy Inc · Riverside, CABuilt 1980 · S/N ME-328 N6719FMichalek Zackery · Myrtle Beach, SCBuilt 1976 · S/N 34-7770034 N671AZPima County Board Of Supervisors · Tucson, AZBuilt 2021 · S/N 20800671 N671MCNorthwestern Michigan College · Traverse City, MIBuilt 2025 · S/N 4496601 N6720TScandinavian Aviation Academy Inc · El Cajon, CABuilt 1980 · S/N ME-335 N6720XCoburn Randy J · Saint George, UTBuilt 1960 · S/N 310-0020 N6724XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1960 · S/N 310-0024 N6725TQuitman LLC · Spartanburg, SCBuilt 1984 · S/N TH-1423 N6726SSchaney Michael W · Brookville, OHBuilt 1983 · S/N TH-1390 N6727XVan Haitsma Kelley · Fort Worth, TXS/N 310-0027 N6728LHancock Aircraft Sales LLC · Baton Rouge, LAS/N TH-1095 N67290Price Edward Rollins Vii · Elon, NCBuilt 1980 · S/N TH-1108 N6729ZMiddle Tennessee Aircraft Services LLC · Mount Pleasant, TNBuilt 1980 · S/N TH-1109 N672AZPima County Board Of Supervisors · Tucson, AZBuilt 2021 · S/N 20800673 N672HBValiair Ltd Co Trustee · Casper, WYBuilt 1977 · S/N 340A0324 N672MCNorthwestern Michigan College · Traverse City, MIBuilt 2026 · S/N 4496640 N6730YUrubek Raymond L · Refugio, TXS/N 27-4062 N6731XThree One X-Ray LLC · Lebanon, OHBuilt 1960 · S/N 310-0031 N6731ZJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeBuilt 1980 · S/N TJ-255 N6734UR E Bentz Inc · Monroe, LAS/N TK-117 N6734XGood Deal Charlie Inc · Russellville, ARBuilt 1980 · S/N TH-1116 N67352Ascension Aviation LLC · Gaylord, MIBuilt 1979 · S/N TH-1098 N6735XLocal Flight Adventures LLC · Morgantown, WVBuilt 1960 · S/N 310-0035 N6739CPearce William · Grants Pass, ORBuilt 1980 · S/N TJ-262 N6739XIntravaia Anthony J · Saint Louis, MOS/N 310-0039 N6739YTropical Interisland Express Corp · Doral, FLBuilt 1968 · S/N 27-4073 N673HPBk Investment Co LLC · Jupiter, FLBuilt 1982 · S/N TH-1326

Back to AD 2004-25-16 R1