Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

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 N1607CAmos Walt · Sandy, UTBuilt 1953 · S/N 30307 N1607DMiko Aviation LLC · Santee, CAS/N 20249 N1607FNurieva Asmar · New Smyrna Beach, FLBuilt 1966 · S/N 17255002 N1607HHanson Jeffrey L · Fuquay Varina, NCBuilt 1975 · S/N 177RG0780 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 N1608CMiller Gerald Roy · Denver, NCBuilt 1953 · S/N 30308 N1608FSmith Tim J · Leasburg, MOBuilt 1966 · S/N 17255003 N1608SNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S9907 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 N1609CBerry John C · Thunderbolt, GABuilt 1953 · S/N 30309 N1609EEilenfeld Teresa · Mansfield, OHBuilt 1978 · S/N 17271065 N1609FHeneghan Tim S · Auburn, WABuilt 1973 · S/N 18052316 N1609XHarvey P J · Midland, TXBuilt 1975 · S/N 21060645 N1609YMapes Steven J · Schenectady, NYBuilt 1962 · S/N 17249309 N160CBBishop Christopher S · Houston, TXBuilt 1966 · S/N 15063780 N160FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272752 N160KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1976 · S/N 15078474 N160MESilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172S8440 N160PYeager Robert F · Cuyahoga Falls, OHBuilt 1962 · S/N 18254278 N160WBBeach Banners Inc · Jacksonville, FLBuilt 1958 · S/N 55238 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 N1610MBreuer Lisa · Horseshoe Bend, IDBuilt 1975 · S/N 18264395 N16114Mcquaid Joseph D · Cosby, TNS/N 15073486 N1611FTripp Michael J · Macon, GABuilt 1966 · S/N 17255006 N1611HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 177RG0784 N16120Av8 Flight Assets LLC · Eden Prairie, MNBuilt 1972 · S/N 15073491 N16125Palmer Earl S Jr · Boise, IDBuilt 1972 · S/N 15073494 N16127Skypark Inc · Wadsworth, OHBuilt 1972 · S/N 15073496 N16128Marquette County Flying Club · Marquette, MIBuilt 1972 · S/N 15073497 N16129Rankin Kevin · Maryville, MOBuilt 1972 · S/N 15073498 N1612CBeck Robert A · Cove, ORBuilt 1953 · S/N 30312 N1612EPavlovitch Marion T · Northridge, CAFirst renewal noticeBuilt 1978 · S/N 17271066 N16134Adibi Saeed · Huntsville, ALBuilt 1976 · S/N 17702485 N16137Hines Roger E · Greenville, OHBuilt 1976 · S/N 17702487 N1613FAde William Henry III Trustee · Tucson, AZBuilt 1966 · S/N 17255008 N1613HHampton William R · Marietta, GAFirst renewal noticeBuilt 1975 · S/N 177RG0786

Back to AD 79-10-14 R1