Skip to content

Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N704NCShaw Paul W · Pecos, TXS/N 15078734 N704NKRebel Aviation Inc · Liberty, MOBuilt 1976 · S/N 15078741 N704NLJ&J Aeronautics LLC · Houston, TXBuilt 1976 · S/N 15078742 N704NQAllard Yoshimi · Carmel, CABuilt 1976 · S/N 15078746 N704NWVan Warmerdam Les C · Nampa, IDBuilt 1976 · S/N 15078752 N704PCJeff Air Pilot Services LLC · Shelbyville, INBuilt 1976 · S/N 15078757 N704PDSale Reported · Peachtree City, GASale reportedBuilt 1976 · S/N 15078758 N704PFBlackburn Andrew J · Rome, GABuilt 1976 · S/N 15078760 N704PHDeters Isaac John · Preston, MNBuilt 1976 · S/N 15078762 N704PKArg Management - Clemson Blvd LLC · Sandy Springs, SCS/N 15078764 N704PMMayes Martin D · Brooklyn, MIBuilt 1976 · S/N 15078766 N704PSSharp Charles B · Fulton, KYS/N 15078771 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 N704QYCarney Robby D · Howe, TXS/N 15078801 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 N704SJLanning 1 Aviation LLC · Amarillo, TXBuilt 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 N704TMZubrod John W · Ebony, VABuilt 1976 · S/N 15078861 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

Back to AD 87-20-03 R2