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.

N64333Sawtooth Aviation LLC · Hovland, MNBuilt 1975 · S/N 17265173 N64334Vrionides Polis G · Collinsville, CTBuilt 1975 · S/N 17265174 N64335Cox Dennis J · Beach City, TXBuilt 1975 · S/N 17265175 N64336Moore Joseph C · Farmers Branch, TXBuilt 1975 · S/N 17265176 N64337Clearwater Airco LLC · Anchorage, AKBuilt 1977 · S/N 18052891 N6433AWagar Dennis Murphy · Marion, MTS/N 33233 N6433EMorgan Peter F · Parma, IDBuilt 1959 · S/N 46533 N6433SDandrea Robert · Portage, PABuilt 1967 · S/N 15067233 N6433TCole Richard J · Rolla, MOBuilt 1985 · S/N R18202022 N6433XRand Carl · Durango, COBuilt 1980 · S/N U20605882 N64340Spartan Aviation Services LLC · Parkland, FLBuilt 1975 · S/N 17265178 N64344Pensacola Navy Flying Club Inc · Pensacola, FLBuilt 1982 · S/N 17275548 N64345Sundstrom Jeffery V · Fresno, CABuilt 1975 · S/N 17265182 N6434NDecker Rufus G III · Arlington, VABuilt 1978 · S/N 21063010 N6434RCutlass Aviation LLC · Auburn, ALBuilt 1985 · S/N 21064926 N64350Byrne David D · Essex Fells, NJBuilt 1975 · S/N 17265185 N64355N64355 LLC · Boulder, COS/N 17265187 N64359Brogan Anni T · Anacortes, WABuilt 1975 · S/N 17265190 N6435BCookson Brian E · Cookson, OKS/N 29635 N6435DMarion Military Institute · Marion, ALBuilt 1979 · S/N 17272799 N6435EForte Aviation Parts Inc · Fort Lauderdale, FLBuilt 1959 · S/N 46535 N6435GMountain Home Aviation Llp · Mountain Home, IDBuilt 1970 · S/N 15071935 N6435SCarney Paul P · Massena, NYBuilt 1967 · S/N 15067235 N6435VKirk James B · Lancaster, SCBuilt 1980 · S/N 172RG0696 N64364B&R Aircraft LLC · Wadsworth, OHBuilt 1975 · S/N 17265194 N64367Hardin John M · Terrell, TXBuilt 1975 · S/N 17265196 N6436BConway Jenna M · Camarillo, CABuilt 1978 · S/N 21062763 N6436FOrnelas Miguel A · Tucson, AZBuilt 1973 · S/N A1500444 N6436PAircraft Leasing LLC · Princeton, MNBuilt 1981 · S/N 15285013 N6436VJones Gregory D · Pueblo, COS/N 172RG0697 N64377Faircloth William H Jr · Morehead City, NCBuilt 1975 · S/N 17265204 N6437ATwin Oaks Aircraft Maintenance LLC · Hillsboro, ORBuilt 1956 · S/N 33237 N6437BBrown Michael W · Merced, CABuilt 1956 · S/N 29637 N6437EFremont Flight Service LLC · Fremont, MIBuilt 1959 · S/N 46537 N6437FWilliams Michael A · Hartsville, INBuilt 1966 · S/N 15063037 N6437SFiresheets William R · Zwolle, LABuilt 1967 · S/N 15067237 N64382Roost Leasing LLC · Sturgis, MIBuilt 1977 · S/N 18052896 N64383Mission Aviation Training Academy · Arlington, WABuilt 1975 · S/N 17265208 N6438AP M Leasing Inc · Perris, CABuilt 1956 · S/N 33238 N6438BEllis Matthew P · Broken Arrow, OKBuilt 1957 · S/N 29638 N6438FRegistration Pending · Everett, WARegistration pendingBuilt 1973 · S/N A1500445 N6438GAero Equities LLC · Ventura, CAS/N 15071938 N6438MKs Aviation Inc · Atwater, CABuilt 1980 · S/N 15284726 N64390Zarpak Shahab Mike · Bethesda, MDBuilt 1982 · S/N 17275552 N6439EBritt Thomas K · Riverview, FLBuilt 1959 · S/N 46539 N6439NSpectraq LLC · Las Vegas, NVBuilt 1978 · S/N 21063015 N6439SKarren Alexander M · Herriman, UTBuilt 1967 · S/N 15067239 N643GAir Leasing Inc · Evanston, ILS/N 15071543 N643UFRegistered aircraftN-number assigned (import), not yet registeredS/N 21064551 N644Wine Street Aviation LLC · Livermore, CABuilt 1982 · S/N R18201927

Back to AD 87-20-03 R2