Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N5367JAir Prescher Airline Limited · Lake Havasu, AZBuilt 2003 · S/N 3257320 N5367LMiller Grady F · Kingsland, TXBuilt 1968 · S/N 28-4673 N53682Fisher Bryce D H · Holly Springs, NCBuilt 2003 · S/N 3257323 N53685Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 3255008 N5368HPacific Flight Aviation LLC · Costa Mesa, CABuilt 2003 · S/N 2843562 N5368JJones Anesthesia LLC · Arcadia, INBuilt 2003 · S/N 2843551 N5368TAviation Here LLC · Lino Lakes, MNS/N 28-7205260 N5369FRegistered aircraftBuilt 1976 · S/N 28-7790102 N5369JMjr Aviation LLC · Boulder Creek, CABuilt 2003 · S/N 3255013 N5369SBuchanan James C · Harwich Port, MABuilt 2003 · S/N 3257329 N536PUMetro Aircraft Co · Bloomington, MNBuilt 1992 · S/N 2841321 N536SCSpartan Education LLC · Tulsa, OKS/N 2881321 N5370FRegistered aircraftBuilt 1976 · S/N 28R-7635460 N5370LSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1968 · S/N 28-4676 N5370TK.M. Biggs Inc · Lumberton, NCBuilt 1972 · S/N 28R-7235228 N5371FCummings Todd Bentley · Westfield, NCBuilt 1976 · S/N 32-7700001 N5373LDavies Patrick · Chula, GABuilt 1968 · S/N 28-4679 N5373THorizon Aviation LLC · Brooks, GABuilt 1972 · S/N 28-7225318 N5374LLund Chris J · Williston, NDFirst renewal noticeBuilt 1968 · S/N 28-4680 N5374TWeaver Stephen E · Enon, OHBuilt 1972 · S/N 28R-7235229 N5375LDerose Kevin L · Janesville, CABuilt 1968 · S/N 28-4681 N5376WJenkins Walter J · Mayfield, UTS/N 28-441 N5377WJackson Timothy J · Hartselle, ALBuilt 1962 · S/N 28-442 N5378LPeterson Dru J · Riverside, CABuilt 1968 · S/N 28-4684 N5378WHargis Bookman LLC · Justin, TXBuilt 1962 · S/N 28-443 N537APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843760 N537FLHanson David Lawrence · Tucson, AZBuilt 1971 · S/N 28-7125367 N5380LLane Joshua J · Eaton, COBuilt 1968 · S/N 28-4687 N5381TBlaes Christopher T · Gallatin, TNBuilt 1972 · S/N 32-7240106 N5382FRose James A · Boston, MABuilt 1976 · S/N 32R-7680520 N5382NHarrell Thomas · Ocala, FLBuilt 1982 · S/N 32-8224012 N5383FN&T Investments LLC · Gulf Shores, ALBuilt 1976 · S/N 32R-7680521 N5383LMo Landings LLC · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N 28-4690 N5384LJohnston Mark A · Duxbury, MABuilt 1968 · S/N 28-4691 N5386FValencia Pedro · Enterprise, ALBuilt 1976 · S/N 28-7715116 N5389WDumont Elizabeth M · College Station, TXBuilt 1962 · S/N 28-457 N538SBBurroughs Scott · Raleigh, NCBuilt 2000 · S/N 3257174 N538SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881431 N5390FHeights Flight Management LLC · Monroeville, NJBuilt 1976 · S/N 32R-7680522 N5390LKnight Ronald J · Mesa, AZBuilt 1968 · S/N 28-5130 N5391LMarchant Kenneth L · Indianola, OKBuilt 1968 · S/N 28-4700 N5391UJohnson Keith Richard · Frostproof, FLBuilt 1979 · S/N 28R-7918033 N5392LYablon Brian M · Portland, ORBuilt 1968 · S/N 28-4701 N5392SBrickhouse Charles F · Wake Forest, NCBuilt 1970 · S/N 28-7125105 N5393SSimpson Randall G · Norwalk, IABuilt 1970 · S/N 28-7125106 N5394FLo Chris · Mesa, AZS/N 28-7725051 N5394WRosanova Richard · Flagstaff, AZBuilt 1962 · S/N 28-462 N5395FRegistration Pending · Granbury, TXRegistration pendingBuilt 1976 · S/N 28-7715118 N5395LPfadenhauer James R · Burlington, IABuilt 1968 · S/N 28-4704 N5396SRiffle Warren C · Gallipolis, OHBuilt 1970 · S/N 28-7125107

Back to AD 87-08-08 R3