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.

N58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeBuilt 1980 · S/N 21063920 N58MARagan Edwin E III · Austin, TXBuilt 1977 · S/N 21062237 N58TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 21062998 N59007Hang On LLC · Montrose, COBuilt 1973 · S/N 21060014 N59008Davis Burton D · Jefferson, IABuilt 1973 · S/N 21060015 N59011Nelson Albert N III · Baytown, TXBuilt 1973 · S/N 21060018 N59041Edwards Aviation & Consulting LLC · Broken Arrow, OKBuilt 1973 · S/N 21060044 N59045Air-Zancada Inc · Wilmington, DEBuilt 1973 · S/N 21060046 N59049Scarry David Charles · San Luis Obispo, CABuilt 1973 · S/N 21060049 N59173Vogelgesang Randy · Gardnerville, NVBuilt 1973 · S/N 21060141 N59258Energy Roofing Technology Se LLC · Lake City, FLS/N 21060180 N59286Staley Ronald L · Lebanon, ORBuilt 1974 · S/N U20602643 N59294Cornucopia Investment Group LLC · South Jordan, UTBuilt 1974 · S/N U20602645 N59ABates Roger · Palm Beach Gardens, FLBuilt 1978 · S/N 21062509 N60018Moreno & Nelson Construction Corp · Walla Walla, WABuilt 1973 · S/N U20602002 N6006NFraser Shane · San Marcos, TXBuilt 1978 · S/N 21062875 N6013BFrost Sean D · Lovell, WYS/N 21062664 N6020NWatts Carl · Thousand Oaks, CABuilt 1978 · S/N 21062888 N6026NWildcat Flying Service Inc · Lakeland, FLS/N 21062894 N6028NBernhard Mark J · Alamo, CABuilt 1978 · S/N 21062896 N602YMSawtooth Aviation Resources LLC · Ketchum, IDBuilt 1981 · S/N U20606231 N6032NHqgt210 LLC · Hugoton, KSBuilt 1978 · S/N 21062900 N6036NMorales Juan · Addison, TXBuilt 1978 · S/N 21062904 N6037BDel Mar Aviation Inc · Wilmington, DEBuilt 1978 · S/N 21062667 N6038BHaarmeyer Air LLC · Lovington, NMBuilt 1978 · S/N 21062668 N603ETSanborn Map Co · Colorado Springs, COBuilt 1973 · S/N U20602230 N6048NAero-Mach Labs Inc · Wichita, KSBuilt 1978 · S/N 21062916 N60636Allard Michael L · Penrose, COS/N 21060596 N6083BListo Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1978 · S/N 21062677 N6084BCenturion Aviation Ltd · Salina, KSBuilt 1978 · S/N 21062678 N608FDMjd Yuma Enterprises LLC · Yuma, AZBuilt 1981 · S/N 21064261 N6094BT 210 Telluride Corp · Aspen, COBuilt 1978 · S/N 21062681 N609RLT And B Mgmt LLC · Las Vegas, NVBuilt 1979 · S/N 21063802 N6100YRamsay Allan Trustee · Modesto, CABuilt 1981 · S/N 21064250 N6103RAta Auto Service Inc · Wilmington, NCBuilt 1965 · S/N T210-0003 N6109RBas Part Sales LLC · Greeley, COBuilt 1965 · S/N T210-0009 N610KCU S Imaging Flight Ops LLC · Bartow, FLBuilt 1981 · S/N 21064258 N6112ABarreto Manufacturing Inc · La Grande, ORS/N 21063498 N6116RAirxn LLC · Williams, AZBuilt 1965 · S/N T210-0016 N6116YSaab35 Draken Inc · Pocono Pines, PAS/N 21064256 N61170Rusty Pilot Holdings LLC · Citrus Heights, CABuilt 1974 · S/N 21060602 N6119ABrender Ronald F Trustee · West Lafayette, INBuilt 1979 · S/N 21063502 N611CCTjc Productions LLC · Ogden, UTBuilt 1979 · S/N 21063600 N611WSFreedom Flight Service LLC · Glendale, AZBuilt 1975 · S/N 21061134 N6126RKelley Kal · Colville, WAS/N T210-0026 N6126YCruise Flight Aviation Inc · Denver, COBuilt 1981 · S/N 21064260 N61275K & K Adventures Inc · Wilmington, DEBuilt 1974 · S/N 21060604 N6127RPhillips Bill · Galt, CABuilt 1965 · S/N T210-0027 N6128ROhop Robert D · Jones, OKBuilt 1965 · S/N T210-0028 N6129RIncline Engineering And Consulting LLC · Ovalo, TXBuilt 1965 · S/N T210-0029

Back to AD 71-09-07 R1