Skip to content

Registered aircraft · 4,469

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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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.

N9791RBlaskovich Thomas M · Highland, CABuilt 1960 · S/N D-6289 N9794YNistico/Weisbart Patricia Ann · Carbondale, COBuilt 1963 · S/N D-7169 N9795RDevins Frederick G · Sussex, NJBuilt 1960 · S/N D-6308 N9795YRick Grossmann & Associates LLC · Overland Park, KSBuilt 1963 · S/N D-7170 N9796RMeadowlake Airpark LLC · Lenoir City, TNBuilt 1960 · S/N D-6327 N9797RGrave Eugene G · Spencer, INBuilt 1960 · S/N D-6334 N9797YPlane Services LLC · Twin Falls, IDBuilt 1963 · S/N D-7286 N9798RMarine Aviation Museum Inc · Wilmington, DEBuilt 1960 · S/N D-6330 N9799RBergen Daniel Michael Jr · Millersville, MDS/N D-6345 N979ABCartwright Jeffry D · Cabool, MOBuilt 1963 · S/N D-7143 N97BJRegistration Pending · Dublin, TXRegistration pendingBuilt 1966 · S/N D-8218 N97WBBowditch Harold W Jr · Lancaster, PABuilt 1967 · S/N D-8386 N9801RMaradei Jefferson V · Mcallen, TXS/N D-6335 N9802RSchutes John T · Brimfield, MABuilt 1960 · S/N D-6314 N9804RCentral Coast LLC · Olympia, WABuilt 1960 · S/N D-6311 N9805RYoder Daniel L · Pond Creek, OKS/N D-6333 N9806RGifford Brent D · Elk City, OKBuilt 1960 · S/N D-6312 N9808RI M Foxbo LLC · Wilmington, DEBuilt 1960 · S/N D-6316 N9809RJimmy Michael Fletcher · Wausa, NES/N D-6460 N980DRJessen Dennis H · Pequot Lakes, MNBuilt 1960 · S/N D-6338 N980QMartinez Marcus · Dana Point, CABuilt 1961 · S/N D-6852 N980SEKfg Aviation Inc · Huntersville, NCS/N D5580 N9810RMccreary William B · Turnersville, NJFirst renewal noticeBuilt 1960 · S/N D-6385 N9814RMankins Kristina · Paso Robles, CABuilt 1960 · S/N D-6325 N9816RV Tail Flyers Group LLC · Deland, FLBuilt 1960 · S/N D-6318 N9817RRegistration Pending · Simms, MTRegistration pendingBuilt 1960 · S/N D-6370 N9818RDurkee Michael S · Amelia, OHBuilt 1960 · S/N D-6323 N981YLavallee David A · Uxbridge, MABuilt 1967 · S/N D-8503 N9821RBender Josh · El Reno, OKBuilt 1960 · S/N D-6355 N9822RHawkins Albert W · Santa Maria, CABuilt 1960 · S/N D-6353 N9823RLettunich John William Jr · Wild Horse, COS/N D-6343 N9826RJacques Jeffrey P · Spokane, WABuilt 1960 · S/N D-6332 N9828RHarbin Billy C · Floydada, TXBuilt 1960 · S/N D-6352 N9830RPollock Craig D · Walnut Creek, CABuilt 1960 · S/N D-6349 N9831RFreilich Richard E · Sugar Land, TXBuilt 1960 · S/N D-6340 N9833RL&M Aircraft Inc · Rome, GABuilt 1960 · S/N D-6357 N9834RBailey Eugene P · Dickinson, TXBuilt 1960 · S/N D-6363 N9835RAviation Hangar LLC · Wentzville, MOBuilt 1960 · S/N D-6359 N9837RWinn Larry V · Tucson, AZBuilt 1960 · S/N D-6369 N9842REdelman Freddie L · Manlius, NYBuilt 1960 · S/N D-6374 N9843RRegistered aircraftBuilt 1960 · S/N D-6361 N9844RAlsworth John H · Anchorage, AKBuilt 1960 · S/N D-6376 N9846RSmith Louis · Dundee, NYBuilt 1960 · S/N D-6379 N9847RWininger Floyd W · Duncan, OKBuilt 1960 · S/N D-6380 N9848RStark James E · Mansfield, TXBuilt 1960 · S/N D-6381 N9849RSmith Tyler · Vancouver, WABuilt 1960 · S/N D-6382 N9850RLeffingwell Thomas W Jr · Wilton Manors, FLBuilt 1960 · S/N D-6401 N9852REverready Aviation LLC · Dickson, TNBuilt 1960 · S/N D-6400 N9853RDwight Hawkins H · Allen, TXBuilt 1960 · S/N D-6404 N9856RMcgrath Stephen · Hawley, PABuilt 1960 · S/N D-6398

Back to AD 94-20-04 R2