Skip to content

Registered aircraft · 1,686

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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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.

N919HWStonehollow Pain Services LLC · Elizabeth, ARS/N 21060054 N920GGAbbott Air Inc · Hydro, OKBuilt 1976 · S/N 21061545 N922MATeton Leasing LLC · Pocatello, IDBuilt 1976 · S/N U20603467 N923EC333 Ranch LLC · Elko, NVBuilt 1977 · S/N 21062299 N925WMVaughn Aviation LLC · Lowell, ARBuilt 1979 · S/N U20604997 N92711Intergard R&D LLC · Miami, FLBuilt 1973 · S/N 21060024 N92DSBooty Bill · Idaho Falls, IDBuilt 1975 · S/N 21060847 N9307YRader Drew · Avon, COBuilt 1981 · S/N 21064467 N9309YYecny Alan K · San Luis Obispo, CABuilt 1981 · S/N 21064469 N93128High Plains Aero Consulting Inc · Pampa, TXBuilt 1974 · S/N 21060273 N93129Klca Inc · Warsaw, INS/N 21060274 N9317MWestwind Aviation Inc · Phoenix, AZBuilt 1980 · S/N 20700680 N93186Bates Byron B · Ethel, WABuilt 1974 · S/N 21060299 N93262Land Office LLC · Burlington, COBuilt 1974 · S/N 21060324 N93274Wltf LLC · Caldwell, IDBuilt 1974 · S/N 21060335 N93285Corrie Brent · Vero Beach, FLBuilt 1974 · S/N 21060341 N93295Gates Steven · Midlothian, TXBuilt 1974 · S/N 21060347 N93344Cardinal Headings Ltd · Wilmington, DES/N 21060371 N93350Rowe M D Trustee · Bozeman, MTBuilt 1974 · S/N 21060372 N93354Utah County Sheriff · Spanish Fork, UTBuilt 1974 · S/N 21060374 N93362Bouvier Ellis C · Prineville, ORBuilt 1974 · S/N 21060377 N93380Stahla Robert E Trustee · Grand Island, NEBuilt 1974 · S/N 21060384 N9338ZBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N U20606404 N9353YKovax Aviation LLC · Youngstown, OHBuilt 1981 · S/N 21064482 N9356YParsons Bruce W Trustee · Costa Mesa, CABuilt 1981 · S/N 21064483 N9369YBk Aviation Services LLC · Yorba Linda, CABuilt 1981 · S/N 21064488 N9379YFitzgerald Aviation LLC · Bluffton, SCBuilt 1981 · S/N 21064491 N93836Clarkson Michael D · Anniston, ALBuilt 1974 · S/N 21060426 N93867Sunup Flyers Coop · Moscow, IDBuilt 1974 · S/N 21060440 N93ETGhatan Farhad · Friday Harbor, WAS/N U20604178 N93HPAxe Capitol Inc · Lake City, FLBuilt 1984 · S/N 21064843 N94035Husbands David · Bosque, NMBuilt 1974 · S/N 21060487 N9403YFlorida Emergency Management Associations Inc · West Palm Beach, FLBuilt 1981 · S/N 21064498 N94148Gates Don · Richmond Hill, GABuilt 1974 · S/N 21060519 N94202Gilsdorf David R Trustee · Pleasant Hill, MOBuilt 1974 · S/N 21060536 N94203Frasier Air Inc · Tulsa, OKBuilt 1974 · S/N 21060537 N94227Dodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N 21060549 N94244Bryant Kenneth D · Black Diamond, WAS/N 21060559 N94263Hitch Aviation Inc · Malta, MTBuilt 1974 · S/N 21060569 N9426KO Max Aviation · Willowbrook, ILBuilt 1974 · S/N 21060572 N942SAWalker John A · Kotzebue, AKS/N TU2060553 N942SMMackie Jonathan M · Manistique, MIBuilt 1969 · S/N T210-0416 N9432MRound Table Aviation LLC · Munster, INFirst renewal noticeBuilt 1970 · S/N 21059332 N9436MIkg Air LLC · Page, AZBuilt 1981 · S/N 20700689 N9438MIdaho Transportation Department · Boise, IDBuilt 1978 · S/N U20604546 N9439YR C S Drilling Company Inc · West Lake Hills, TXBuilt 1981 · S/N 21064505 N9465YWof Investments LLC · Dover, DES/N 21064515 N9472MValentine Kurt J · Apple Valley, MNBuilt 1970 · S/N 21059372 N9475RVon Imhof Rudi F · Anchorage, AKBuilt 1985 · S/N U20606872 N9479GCox Ramona T · Manhattan Beach, CABuilt 1971 · S/N U20601679

Back to AD 71-09-07 R1