Skip to content

Registered aircraft · 47,138

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

N336LBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 336-0117 N336LMKlm Unlimited Inc · Staples, MNS/N E-1587 N336LVMarti Jorge · Miami, FLBuilt 1964 · S/N 336-0176 N336MTNorth Peak Aviation LLC · Waunakee, WIBuilt 1999 · S/N E-3265 N336NANickravesh Niknam J · Saratoga, CABuilt 1980 · S/N E-480 N336PWCajan LLC · Kings Mountain, NCBuilt 1982 · S/N EA-297 N336RDByone Steve · Natchitoches, LABuilt 1996 · S/N E-3008 N336RWBe5816 LLC · Simi Valley, CABuilt 2005 · S/N E-3636 N336SQla Air LLC · Fort Myers, FLBuilt 2013 · S/N E-3989 N336TTophatter85 LLC · Kirksville, MOBuilt 1978 · S/N E-1219 N336TWPair Of Minutes LLC · Marshville, NCBuilt 1963 · S/N 336-0147 N336VRVr Jet LLC · Goshen, INBuilt 1963 · S/N 336-0024 N336W336 LLC · Eagle, IDBuilt 1963 · S/N 336-0156 N336ZGoodman Michael R · New Brighton, PABuilt 1960 · S/N D-6489 N33702Hood Frank A · Burlington, NCBuilt 1967 · S/N 337M-0142 N3370SWittenborn Grant A · Olathe, KSBuilt 1973 · S/N 18502281 N3370UBriannas Wings Of Passion Foundation Inc · Magalia, CABuilt 1963 · S/N 18254770 N3370YBrink Brittnie L · Baldwin, WIBuilt 1962 · S/N 18254370 N3371FRavens Rebuilders Inc · Ellenboro, WVS/N 18257371 N3371LAgresti Harold David · Ceres, CABuilt 1967 · S/N 185-1323 N3371YChavers Finley L · Newnan, GABuilt 1962 · S/N 18254371 N33724Mil2atp Inc · Pikeville, NCS/N 34-7570153 N3372DWings Like Eagles Aviation LLC · Newnan, GABuilt 1955 · S/N 32170 N3372FSwanner Robert Craig II · Water Valley, MSBuilt 1966 · S/N 18257372 N3372SBmf Services USA LLC · Satellite Beach, FLBuilt 1969 · S/N 21059172 N3372ULeading Edge Operations LLC · Knoxville, TNBuilt 1963 · S/N 18254772 N33739Sale Reported · Crystal, MNSale reportedBuilt 1975 · S/N 34-7570154 N3373DCarpenter Marshall Owen · Isanti, MNBuilt 1956 · S/N 32171 N3373LHowell Nicholas A · Englewood, COBuilt 1967 · S/N 185-1325 N3373RSkylane N3373r LLC · Rancho Cucamonga, CABuilt 1967 · S/N 18258673 N3373SWestern Metal Products LLC · Ellensburg, WABuilt 1964 · S/N 18255390 N3373URms Industrial Sales LLC · Neenah, WIBuilt 1963 · S/N 18254773 N3374DScootair LLC · Alburgh, VTBuilt 1955 · S/N 32172 N3374LLewallen William J · Eloy, AZBuilt 1967 · S/N 185-1326 N3374SCcf Ventures Inc · Bangor, MEBuilt 1969 · S/N 21059174 N3374UMurphy & Son Construction Inc · Brownsville, VTBuilt 1963 · S/N 18254774 N3374YRegistered aircraftBuilt 1962 · S/N 18254374 N3375DQualls Randy J · Claremore, OKBuilt 1955 · S/N 32173 N3375FKintner William R · Port Angeles, WABuilt 1966 · S/N 18257375 N3375LRowan William · New Fairfield, CTBuilt 1967 · S/N 185-1327 N3375RRoyellair LLC · Stone Mountain, GABuilt 1967 · S/N 18258675 N3376DHammond James F · Yellow Springs, OHBuilt 1955 · S/N 32174 N3376GLindsay Aviation Inc · West Seneca, NYBuilt 1976 · S/N 310R0818 N3376RStumm Robert W · Cadott, WIBuilt 1967 · S/N 18258676 N3376YFly Greater Breezewood LLC · Clearville, PABuilt 1962 · S/N 18254376 N3377RLonestar Aeronautics LLC · Paige, TXBuilt 1967 · S/N 18258677 N3378UJeppson Edward M · Nephi, UTBuilt 1963 · S/N 18254778 N3379UJames Mccullough · Hempstead, TXBuilt 1963 · S/N 18254779 N337AFKinetic Concepts LLC · Pensacola, FLBuilt 1967 · S/N 67-21344 N337ARRegistration Pending · Medford, ORRegistration pendingBuilt 1955 · S/N G-269

Back to AD 2000-23-21