Skip to content

Registered aircraft · 26,231

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-05-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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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.

N16045Dragseth Joseph M · Kenai, AKS/N 15073437 N16046Sky Walker Flight School LLC · Adrian, MIBuilt 1972 · S/N 15073438 N16048Maki Eric · Duncanville, TXBuilt 1972 · S/N 15073440 N16049Hasselbring Ted · Nashville, TNBuilt 1972 · S/N 15073441 N1604FMorse Mark H · Lake Stevens, WABuilt 1966 · S/N 17254999 N1604QBuck Fifty LLC · Freeport, ILBuilt 1971 · S/N 15072904 N1604VShuel Dale W · Brighton, COBuilt 1947 · S/N 13776 N1604YOcean Isle Aviation · Ocean Isle Beach, NCBuilt 1962 · S/N 17249304 N16051Wells Michael Perry · Thompson Falls, MTBuilt 1972 · S/N 15073442 N16053Drain Dennis R · Ferndale, WABuilt 1972 · S/N 15073444 N16057Renner Thomas J · Williston, NDS/N 15073447 N16058Northwest Wings LLC · Hillsboro, ORBuilt 1972 · S/N 15073448 N1605NGraham Douglas R · Palmer, AKS/N 390 N1605VLindsey Allie Ayers · Lamont, OKBuilt 1947 · S/N 13777 N16064Wyatt Scott A · Tehachapi, CABuilt 1972 · S/N 15073451 N1606QChappell Nathan T · Glasgow, MTBuilt 1971 · S/N 15072906 N1606VWeatherproof Montana LLC · Missoula, MTBuilt 1947 · S/N 13778 N1606YFellows James S Jr · Fawnskin, CABuilt 1962 · S/N 17249306 N16073Hobbs Mitchell J · The Villages, FLBuilt 1972 · S/N 15073456 N16074Derstine Ernest B · Pantego, NCS/N 15073457 N16079El Ghawi Andre · Venice, FLBuilt 1972 · S/N 15073461 N1607DMiko Aviation LLC · Santee, CAS/N 20249 N1607FNurieva Asmar · New Smyrna Beach, FLBuilt 1966 · S/N 17255002 N1607KPerdue Sandy L · Asheboro, NCBuilt 1946 · S/N 4334 N1607NHuntley Lawrence H · Hernando, FLBuilt 1946 · S/N 392 N16080150 Flyers LLC · Waterford, MIFirst renewal noticeS/N 15073462 N16084Lawson Roger E · Elizabethtown, KYBuilt 1972 · S/N 15073465 N16088Wyrosdick Benjamin S · Hoover, ALBuilt 1972 · S/N 15073467 N1608FSmith Tim J · Leasburg, MOBuilt 1966 · S/N 17255003 N1608NKankakee Valley Aviation LLC · Wanatah, INBuilt 1946 · S/N 393 N1608YKohr Daniel E · Bartlett, TNBuilt 1962 · S/N 17249308 N16091Timm Mark W · Ithaca, NEBuilt 1972 · S/N 15073469 N16093Hanus Aviation LLC · Kenyon, MNBuilt 1972 · S/N 15073471 N16097Crosswind Capital LLC · Castle Rock, COBuilt 1972 · S/N 15073474 N1609NFunk Aeroplane Company · Basehor, KSBuilt 1946 · S/N 394 N1609YMapes Steven J · Schenectady, NYBuilt 1962 · S/N 17249309 N160GManley Alan E · Longmont, COBuilt 1967 · S/N 25 N160KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1976 · S/N 15078474 N160LCBlack And Waldorf Inc · Marathon, FLBuilt 2011 · S/N AL-1160 N16101Hatch David G · Clovis, CAS/N 15073477 N16105Stevenson Rodrick Albert · Smyrna, GABuilt 1972 · S/N 15073480 N16107Scheck Robert C · Chicago, ILBuilt 1972 · S/N 15073481 N16108Longsroad LLC · Carefree, AZBuilt 1972 · S/N 15073482 N16109Registration Pending · Mundelein, ILRegistration pendingBuilt 1972 · S/N 15073483 N1610FFrahm Lon R · Colby, KSBuilt 1966 · S/N 17255005 N1610VSale Reported · Lisbon, OHSale reportedBuilt 1947 · S/N 13782 N16114Mcquaid Joseph D · Cosby, TNS/N 15073486 N1611FTripp Michael J · Macon, GABuilt 1966 · S/N 17255006 N1611NHistoric Aircraft Restoration Museum · Saint Louis, MOFirst renewal noticeBuilt 1947 · S/N 411 N1611VRevak Ben · Dousman, WIBuilt 1947 · S/N 13783

Back to AD 94-05-05 R1