Skip to content

Registered aircraft · 10,639

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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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.

N5616YBigfoot Aviation LLC · Wilmington, DEBuilt 1965 · S/N 18-8287 N5618ZNull Clifford M · Punxsutawney, PABuilt 1962 · S/N 22-9430 N5619HFranklin Vernon L · Aguila, AZBuilt 1949 · S/N 16-230 N5622HHallum Randal · Wewoka, OKBuilt 1949 · S/N 16-233 N5623ZQuinlan John H · Claxton, GABuilt 1962 · S/N 22-9435 N5624HCameron Thomas W · Lennon, MIS/N 16-235 N5625ZBellamy John Mark · Freeville, NYBuilt 1962 · S/N 22-9437 N5626HWhitmore Martha J · Terlingua, TXBuilt 1949 · S/N 16-237 N5628HGade Dale Alan · Antioch, ILS/N 16-239 N5631HBoyd Cecil E · Chocowinity, NCBuilt 1949 · S/N 16-242 N5631ZMooney Timothy · Hedgesville, WVBuilt 1962 · S/N 22-9443 N5632ZEakin Andrew C · Franklin, PABuilt 1962 · S/N 22-9444 N5636ZYoung Harold E · Jamestown, NYS/N 22-9448 N5637ZKutcher Dennie L · Galeton, COBuilt 1962 · S/N 22-9449 N5638HHoudek Dennis E · Roseburg, ORBuilt 1949 · S/N 16-249 N5639HKruse Bryan J · Bethel, AKBuilt 1949 · S/N 16-250 N5640HMitchell Zachary · Franklin, NHBuilt 1949 · S/N 16-251 N5641ZScout Aviation LLC · Arnaudville, LAS/N 22-9460 N5642HSlaughter Don W · Farmville, NCFirst renewal noticeBuilt 1949 · S/N 16-253 N5644HPoliti Terris P · Lake Placid, NYBuilt 1949 · S/N 16-255 N5644ZVon Drashek Bruce P · Prior Lake, MNBuilt 1962 · S/N 22-9461 N5645HYoder James J · Canby, ORS/N 16-256 N5646HRiley Matthew M · White Salmon, WABuilt 1949 · S/N 16-257 N5649ZDyson Keith A · Port Townsend, WABuilt 1962 · S/N 22-9472 N5651HCramer Nicholas R · Lexington, OHS/N 16-262 N5652ZClifford Karl N · Lubbock, TXBuilt 1962 · S/N 22-9475 N5655HRansdell Elise A · Springfield, ILBuilt 1947 · S/N 16-266 N5655ZTroth Gary D · Mound City, KSBuilt 1962 · S/N 22-9478 N5656HCaldwell Joel · Galveston, TXS/N 16-267 N5656YD & D Airpark LLC · Anchorage, AKBuilt 1965 · S/N 18-8290 N56599Hetge Kenneth R · Tehachapi, CABuilt 1941 · S/N 4-1612 N5661HSullivan Thomas S · Quinnesec, MIBuilt 1949 · S/N 16-272 N5664HPierce Stephan L · Graham, TXBuilt 1949 · S/N 16-275 N5665ZPerez John-Henry · Locust Grove, GABuilt 1962 · S/N 22-9488 N5666ZWheeler James R · Falling Waters, WVBuilt 1962 · S/N 22-9489 N5667HLeader Russell J · Glasgow, MTS/N 16-278 N5669HUsaviation.Com LLC · Moorestown, NJBuilt 1949 · S/N 16-280 N5671ZQualls William C · Wellsville, KSBuilt 1962 · S/N 22-9495 N5672HPound Haley E · Temple, TXBuilt 1949 · S/N 16-283 N5673HMalone William Z · Mount Nebo, WVS/N 16-284 N5675HGreen William C · Mancelona, MIBuilt 1949 · S/N 16-290 N5676HDart Gregory G · Mayville, NYBuilt 1949 · S/N 16-286 N5676ZHenderson Joseph C · Midlothian, VABuilt 1963 · S/N 22-9502 N5678YTaildragger LLC · Glade Spring, VAS/N 18-8317 N5680HEpting Robert L · Chapel Hill, NCBuilt 1949 · S/N 16-292 N5680YSchildberg Gregory M · Casey, IABuilt 1965 · S/N 18-8292 N5681ZCalvert Scott R · Pequannock, NJBuilt 1962 · S/N 22-9508 N5683ZPalmenteri Louis · Rhome, TXBuilt 1962 · S/N 22-9512 N5684ZMuehlberg Stephen E · Newcastle, OKBuilt 1962 · S/N 22-9514 N5688HSheradin Roland R · Cape Coral, FLBuilt 1949 · S/N 16-300

Back to AD 99-01-05 R1