Skip to content

Registered aircraft · 20,683

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.

N3641LSeaplanes R Fun Inc · Wilmington, DEBuilt 1965 · S/N 17253810 N3642LMetro Technology Centers · Oklahoma City, OKBuilt 1965 · S/N 17253811 N3643SMaycroft David · Cary, ILBuilt 1963 · S/N 17250843 N3644LHobbie Roy Lee · Cynthiana, KYBuilt 1965 · S/N 17253813 N3644SMurray William · East Jordan, MIBuilt 1963 · S/N 17250844 N3644TArizona Air Salvage · Phoenix, AZS/N 17260849 N3645LRegistered aircraftBuilt 1965 · S/N 17253814 N3646LRobert Roger J · Gardner, MABuilt 1965 · S/N 17253815 N3646SCummings Larry D · Clarence, NYBuilt 1966 · S/N 17254827 N3647LEmmett Kerry N · Greeneville, TNBuilt 1965 · S/N 17253816 N3648LGlenn William · Marion, NCBuilt 1965 · S/N 17253817 N3649LArmour Walton H · Alliance, OHBuilt 1965 · S/N 17253818 N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354 N364CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8803 N364DRegistered aircraftBuilt 2014 · S/N 172S11373 N364GWHdh Aircraft Leasing LLC · Carrollton, TXBuilt 2003 · S/N 172S9364 N364MAJet Air Inc · Iowa City, IABuilt 1998 · S/N 172S8007 N364MSSkyhawk Aviation LLC · Omaha, NEBuilt 1997 · S/N 17280015 N364SAJackson Edwin W · Tampa, FLBuilt 1999 · S/N 17280757 N364SPVermont Flight Academy · South Burlington, VTBuilt 2001 · S/N 172S8782 N364SRSales Joe H DBA · Seminole, TXBuilt 1964 · S/N 17251558 N3650LTom Wrolstad Aircraft LLC · Molalla, ORBuilt 1965 · S/N 17253819 N3652LJbm Aviation LLC · Mc Leansboro, ILBuilt 1965 · S/N 17253821 N3653LRistau Kent T · Eagle Grove, IABuilt 1965 · S/N 17253822 N3654LHeritage In Flight Museum Inc · Lincoln, ILBuilt 1965 · S/N 17253823 N3656SBell Michael L · Spokane, WAS/N 17250856 N3657LHollabaugh David S · Fulton, MOBuilt 1965 · S/N 17253826 N3657SIsakson Dennis E · Van Tassell, WYBuilt 1963 · S/N 17250857 N3658LGraczyk Michael E · Lake Elmo, MNBuilt 1965 · S/N 17253827 N3658SOrlovich John A · Boise, IDS/N 17250858 N3659SWeed Thomas W · Limington, MEBuilt 1963 · S/N 17250859 N365CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8838 N365ESLakewood Investments LLC · Victorville, CABuilt 1997 · S/N 17280023 N365PCWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271033 N365SPClow International Airport LLC · Bolingbrook, ILBuilt 2001 · S/N 172S8783 N3660LBersig James R · La Palma, CAS/N 17253829 N3661SMiller Harvey L · Livonia, MIBuilt 1963 · S/N 17250861 N3662LPrice John C · Bennington, KSBuilt 1965 · S/N 17253831 N3663SFranks Richard W · Moville, IAS/N 17250863 N36645Kaufmann Chad · Lewiston, IDBuilt 1958 · S/N 36645 N3664LNixon Robert W · Mc Alpin, FLBuilt 1965 · S/N 17253833 N3664SWasson Tom L · Lakeport, CABuilt 1963 · S/N 17250864 N3666SBerry Mike J · Palo Cedro, CABuilt 1963 · S/N 17250866 N3667SOliva Louis F III · Anchorage, AKS/N 17250867 N3668LMaui Skyhawks Inc · Kula, HIBuilt 1965 · S/N 17253837 N3668SWm Aviation LLC · Moncks Corner, SCBuilt 1963 · S/N 17250868 N3669LNovacek Jeffrey J · Minneapolis, MNBuilt 1965 · S/N 17253838 N3669SKeller Kenneth Ray Jr · Jonesboro, ARS/N 17250869 N366CTAia Charlie LLC · Henderson, NVBuilt 2025 · S/N 172S13341 N366STN366st LLC · Kenesaw, GABuilt 2025 · S/N 172S13331

Back to AD 90-06-03 R1