Skip to content

Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N7892UAirtime Aviation LLC · Cabot, ARBuilt 1964 · S/N 17251892 N78938Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257794 N7893GRegistration Pending · Bucyrus, OHRegistration pendingBuilt 1970 · S/N 17259593 N7893UMiller Bryan L · Somonauk, ILBuilt 1964 · S/N 17251893 N7894GAr Aero Services LLC · Sacramento, CABuilt 1970 · S/N 17259594 N7894TGriggs Howard D · Crestline, CABuilt 1960 · S/N 47494 N7894UPetty Robert J · Carson City, NVBuilt 1964 · S/N 17251894 N7895XVerhalen John P Jr · Scottsville, TXBuilt 1961 · S/N 17248395 N78978Martin Gary P · Boonville, MOBuilt 1968 · S/N 17257796 N7897TFunk Kenneth E · Warner Robins, GABuilt 1960 · S/N 47497 N7897UFischer Duane A · New Baden, ILBuilt 1964 · S/N 17251897 N7898GMccutcheon Frank Jr · Scottsboro, ALBuilt 1970 · S/N 17259598 N7899UDeidiker Floyd D · West Plains, MOBuilt 1964 · S/N 17251899 N7899XHines Jairus B · Lenoir City, TNBuilt 1961 · S/N 17248399 N789BGM9c146 Aviation LLC · Boynton Beach, FLBuilt 2000 · S/N 17280938 N789CEBond Brent L · Clearwater, KSBuilt 1978 · S/N 17270536 N789EPEastbourne Holdings LLC · Woodstock, GAFirst renewal noticeBuilt 1999 · S/N 172S8135 N789FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13167 N789PFSherman Aviation LLC · Fairfield, NJBuilt 2011 · S/N 172S11115 N789RAMiller Melanie L · Spanaway, WABuilt 1976 · S/N 17267184 N789SSummit Aircraft LLC · Seattle, WABuilt 1963 · S/N 17250862 N78ERFreeway Airport Inc · Mitchellville, MDBuilt 1983 · S/N 17276003 N79000Kemmis Sidney C · Prophetstown, ILBuilt 1968 · S/N 17257797 N79001Pau Hana Enterprises LLC Series IV · Boulder City, NVBuilt 1968 · S/N 17257798 N79002Fremont Aviation Inc · Fremont, NES/N 17257799 N79004Palmer Joe A · Meridian, IDBuilt 1968 · S/N 17257801 N79009Birkholz Raymond J · Boulder, COBuilt 1968 · S/N 17257806 N7900GGreat Plains Enterprises LLC · Wilmington, OHBuilt 1970 · S/N 17259600 N7900UJames Timothy C · Morehead, KYBuilt 1964 · S/N 17251900 N79012Brewer Jeremiah L · Eagle River, AKBuilt 1968 · S/N 17257809 N79013Woods Michael F · Hamilton, NJBuilt 1968 · S/N 17257810 N79014Fcs Aviation LLC · Lewisport, KYBuilt 1968 · S/N 17257811 N79015Flying Weaners Inc · Jacksonville, FLBuilt 1968 · S/N 17257812 N7901BCantrell Dennis · Conway, ARBuilt 1957 · S/N 29701 N7901GRaines Adam D · Ridgewood, NJBuilt 1970 · S/N 17259601 N79021Smith Timothy C Trustee · Riverton, WYS/N 17257816 N79024Jwp Flying Services LLC · Chatfield, MNBuilt 1968 · S/N 17257819 N79027Arrow North LLC · Missoula, MTBuilt 1968 · S/N 17257822 N79028Jdc Aviation LLC · Upland, CABuilt 1968 · S/N 17257823 N79031Smith Robert L II · Spencer, WVBuilt 1968 · S/N 17257826 N79036Buiqui Aerospace Corp · Kissimmee, FLS/N 17257831 N7903BHenderson Ethan D · Argyle, NYBuilt 1957 · S/N 29703 N7903GDunn Patrick J · Denver, COBuilt 1970 · S/N 17259603 N7903UCohen Bruce Robertson · Estes Park, COBuilt 1964 · S/N 17251903 N79040Higinbotham Larry L · Littleton, COBuilt 1968 · S/N 17257835 N79042N79042 LLC · Rock Hill, SCBuilt 1968 · S/N 17257837 N79048High Stakes Aviation LLC · Fresno, CABuilt 1968 · S/N 17257841 N7904BWagoner Darrin G · Red Oak, TXBuilt 1957 · S/N 29704 N7904GRight Rudder LLC · Rexburg, IDBuilt 1970 · S/N 17259604 N7904XWishart Eric G · Reno, NVBuilt 1961 · S/N 17248404

Back to AD 90-06-03 R1