Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N704PMMayes Martin D · Brooklyn, MIBuilt 1976 · S/N 15078766 N704PVTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1976 · S/N 15078774 N704PWGwinn Anthony N · Grand Haven, MIBuilt 1976 · S/N 15078775 N704QAWashington State Community College · Spokane, WABuilt 1976 · S/N 15078779 N704QBDu Christopher T · Nolensville, TNBuilt 1976 · S/N 15078780 N704QFBevan Michael A · Seabeck, WABuilt 1977 · S/N 15078784 N704QHPfisters Flying Wahaine LLC · Waialua, HIBuilt 1976 · S/N 15078786 N704QLHall Jeffery · Farmington, MNBuilt 1976 · S/N 15078789 N704QMWells Greg DBA · Woodbury, MNBuilt 1976 · S/N 15078790 N704QPDornink Steven R · Freeport, ILBuilt 1976 · S/N 15078792 N704QSSperling Deborah E · Lincoln, MABuilt 1976 · S/N 15078795 N704RCHuffman Jacob M III · Burleson, TXBuilt 1976 · S/N 15078805 N704RFTaylor Casey J · Lindsay, OKBuilt 1976 · S/N 15078808 N704RGStankovits Zachary P · Henderson, NVBuilt 1976 · S/N 15078809 N704RMHarwood F Douglas · Hartford, NYBuilt 1976 · S/N 15078814 N704RPGreenstein Jeffrey P · Centennial, COBuilt 1976 · S/N 15078816 N704RQBilbrey Todd B · Tulsa, OKBuilt 1976 · S/N 15078817 N704RSBreaking Ground Ministries Inc · Fayetteville, ARBuilt 1976 · S/N 15078819 N704RVPalmer Don W · Penhook, VABuilt 1976 · S/N 15078822 N704RYBoeing Employees Flg Assoc Inc · Renton, WABuilt 1976 · S/N 15078825 N704SEMichler Jon D · Jasper, TXS/N 15078831 N704SJBellas Business LLC · Kalispell, MTBuilt 1976 · S/N 15078835 N704SLPhelps Clay DBA · Santa Paula, CABuilt 1976 · S/N 15078837 N704SSFatell David Aaron · Ottawa Lake, MIBuilt 1976 · S/N 15078843 N704SUWeiser Leonard · Westminster, MABuilt 1976 · S/N 15078845 N704SXPropeller Enterprises LLC · Gilbert, AZBuilt 1976 · S/N 15078847 N704SYMiller Dale R · Highland, ILBuilt 1976 · S/N 15078848 N704TDFlight Gear Aviation LLC · Pickerington, OHS/N 15078853 N704THCalderon Ed · Tracy, CABuilt 1976 · S/N 15078857 N704TQDolphin Capital LLC · Brooksville, FLS/N 15078864 N704TUFilkins Randy A · Wellsburg, WVBuilt 1976 · S/N 15078868 N704TVStrickland Kenneth Louis · Cary, NCBuilt 1976 · S/N 15078869 N704TXGenna Vito V Jr · Newfield, NJBuilt 1976 · S/N 15078871 N704TZBrekke Ryan · Edmore, NDBuilt 1976 · S/N 15078873 N704UAPrince John R · West Chester, OHBuilt 1976 · S/N 15078874 N704UCFirst South Partners Inc · Melbourne Beach, FLBuilt 1976 · S/N 15078876 N704UDDavis Norman E · Dunnellon, FLBuilt 1976 · S/N 15078877 N704UEWillpower Aviation LLC · Litchfield Park, AZBuilt 1976 · S/N 15078878 N704UFKimani Derrick M · Panorama Village, TXBuilt 1976 · S/N 15078879 N704UHCappiello Robert M · Santa Clarita, CAS/N 15078881 N704UPHayenga Sandra A · Granbury, TXBuilt 1976 · S/N 15078887 N704URWalker Richard D · Houston, TXBuilt 1976 · S/N 15078889 N704UTCp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 15078891 N704UWJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 15078894 N704UXHlavac Mathew B · Ramona, CABuilt 1976 · S/N 15078895 N704UYTotal Aircraft Service Inc · Sherwood, ARBuilt 1976 · S/N 15078896 N704VFRegistered aircraftS/N 15078903 N704VLHattayer John M · Plainfield, CTBuilt 1976 · S/N 15078908 N704VMRegistration Pending · Navarre, FLRegistration pendingBuilt 1976 · S/N 15078909 N704VTNye Andre Marcus · Naples, FLS/N 15078914

Back to AD 94-05-05 R1