Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N5337ZBrown Estates Aviation LLC · Fresno, CABuilt 1961 · S/N 22-9047 N533KCTidd Scott · Reading, MIBuilt 1963 · S/N 27-2390 N5340PDejulio Jan A · Temecula, CABuilt 1958 · S/N 24-385 N5341ZAtp Aircraft 4 LLC · Wilmington, DEBuilt 2001 · S/N 4496107 N5343ZGolden Age Aeroworks LLC · Lone Rock, WIBuilt 1962 · S/N 22-9059 N5344YMerced County Mosquito Abatement District · Merced, CABuilt 1963 · S/N 27-2418 N5346PBelt David Jr · White Hall, MDBuilt 1958 · S/N 24-391 N5348PPari Aviation LLC · Marion, TXBuilt 1958 · S/N 24-395 N5348ZDavis Robert D · Shongaloo, LABuilt 1961 · S/N 22-9068 N5350ZAgalotis Paul E · San Martin, CABuilt 1961 · S/N 22-9071 N5351ZGostola Thomas · Fairmount, INBuilt 1961 · S/N 22-9072 N5352BRegistered aircraftBuilt 1958 · S/N 24-406 N5352ZMcdougall Michael D · Caldwell, IDBuilt 1961 · S/N 22-9075 N5354NPinnacle Aviation Services Inc · Encinitas, CABuilt 2002 · S/N 4496160 N5354ZManson Timothy C · New Gloucester, MEBuilt 1961 · S/N 22-9077 N5355ZWatts Carrie L · Hazen, NVBuilt 1961 · S/N 22-9078 N5356UAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2002 · S/N 4496164 N5358PWilliams George A · Bonifay, FLBuilt 1958 · S/N 24-306 N5359PPanhandle Groundwater Conservation District · White Deer, TXBuilt 1958 · S/N 24-408 N5359YMajeste Air LLC · Loveland, COBuilt 1963 · S/N 27-2432 N5359ZSale Reported · Crozet, VASale reportedS/N 22-9085 N5360PN5360p LLC · Blacklick, OHBuilt 1958 · S/N 24-409 N5363YThompson Frank L · Weiser, IDBuilt 1963 · S/N 27-2437 N5364ZHughes Tony W · Irmo, SCBuilt 1961 · S/N 22-9094 N5365PLarsen Roy E · Placerville, CAS/N 24-414 N5366PGreenlaw Russell C · Livermore, CABuilt 1958 · S/N 24-415 N5367ZAdvance Aviation Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1961 · S/N 22-9099 N5368PHeck Paul A · Santa Rosa, CABuilt 1958 · S/N 24-417 N5368ZTevik Michael A · Provo, UTBuilt 1961 · S/N 22-9100 N5370PBlythe Anne T · Paso Robles, CABuilt 1958 · S/N 24-420 N5374PDeflorin David J · Harris, MNBuilt 1958 · S/N 24-424 N5374ZMyers Kenneth Jerome · Haines, ORBuilt 1961 · S/N 22-9140 N5376PDuffield Michael · Sorrento, FLS/N 24-426 N5377PRegistration Pending · Litchfield Park, AZRegistration pendingBuilt 1958 · S/N 24-427 N5377ZTurner Edward J III · Mokena, ILBuilt 1961 · S/N 22-9139 N5379ZMcelwee Glenda A · Lake City, FLS/N 22-9146 N537DMKrakoff Matthew · Massapequa, NYBuilt 1969 · S/N 30-1863 N5380ZHerrema James M · Fountain, MIBuilt 1961 · S/N 22-9147 N5381PRiggs Michael · Yoder, COBuilt 1958 · S/N 24-432 N5381ZRasmussen Mark · Hogeland, MTBuilt 1961 · S/N 22-9149 N5382PBryant Ashley Kae · Fort Worth, TXBuilt 1958 · S/N 24-433 N5386PRendezvous Air LLC · Riverton, WYBuilt 1958 · S/N 24-437 N5386YKunka Michael A · Lincoln Park, MIBuilt 1963 · S/N 27-2459 N5386ZKetcham Blake L · Turtle Creek, PABuilt 1961 · S/N 229154 N5387PStewart Aaron K · Murdock, NEBuilt 1958 · S/N 24-438 N5387ZHester Nathan A · El Centro, CABuilt 1961 · S/N 22-9156 N5388PHeadings Andrew R · Blue River, WIBuilt 1958 · S/N 24-439 N5388ZHarcourt Tim J · Libby, MTBuilt 1961 · S/N 22-9157 N5389PJaehn Lawrence E · El Cajon, CABuilt 1958 · S/N 24-440 N538PMueller Lawrence A · Jackson, GAS/N 24-538

Back to AD 85-02-05 R1