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.

N2087YEllsworth Matthew R · Fairbanks, AKBuilt 1963 · S/N 17249587 N2087ZFischer Gary H · Savannah, GABuilt 1963 · S/N 15059887 N20882Stuart Roger G Jr · Mount Pleasant, TXBuilt 1972 · S/N 18261283 N20884Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12581 N20888Baker Michael A · Watsonville, CABuilt 1972 · S/N 18261287 N2088RRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1964 · S/N 18255288 N2088USimpson Equipment Leasing LLC · Hays, KSBuilt 1982 · S/N U20606610 N2088YHowell Rebecca Elizabeth · Elgin, TXBuilt 1962 · S/N 17249588 N20890Thomas Brett · Gettysburg, PABuilt 1972 · S/N 18261289 N20891Morristown Flying Service Inc · Talbott, TNBuilt 1974 · S/N 17263867 N2089ESkyhawk N2089e Ltd · Deerfield, ILBuilt 1978 · S/N 17271151 N2089QKelly Daniel W · Conway, SCBuilt 1974 · S/N 177RG0489 N2089XMoravitz Kim J · Turtle Lake, WIBuilt 1965 · S/N 18256189 N2089YSooter Craig A · Sedgwick, KSBuilt 1962 · S/N 17249589 N208ATLeciejewski Darrell K · Mc Alpin, FLBuilt 1976 · S/N 17268379 N208CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12502 N208KCAcevedo Adriel · San Antonio, TXS/N 15070435 N208LHOtt Grosvenor LLC · Dillingham, AKBuilt 1974 · S/N U20602642 N208SSSeldom Seen Aviation Northwest Inc · Stevensville, MTBuilt 1974 · S/N 18502452 N208TCKissee Zachary Robert · Chugiak, AKBuilt 1976 · S/N 18052749 N208WPCassidy Ryan H · Seattle, WABuilt 1980 · S/N U20605836 N20907Ward Roger L · Ghent, WVBuilt 1972 · S/N 18261345 N2090GLight Chop LLC · Lexington Park, MDBuilt 1958 · S/N 51390 N2090QRawls Mike E · New Waverly, TXS/N 177RG0490 N2090XTreeline Services LLC · Grimes, IAS/N 18256190 N2090YKilbey Bryan E DBA · Defuniak Springs, FLS/N 177RG1106 N2090ZRegistered aircraftRegistration pendingBuilt 1963 · S/N 15059890 N20910Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12582 N20913Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12583 N20914Jackson George F Jr · Saint Leonard, MDBuilt 1972 · S/N 18261294 N2091QJohnson Earl V · Andalusia, ALBuilt 1974 · S/N 177RG0491 N2091XBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 18256191 N2091YCut And Snip Flyers LLC · South Weber, UTBuilt 1962 · S/N 17249591 N20920Berry Danny · Rusk, TXBuilt 1972 · S/N 18261295 N20921Brigham David F · Elliottsville Twp, MEBuilt 1974 · S/N 17263869 N20923Langford Thomas R Jr · Mount Clare, WVBuilt 1972 · S/N 18261298 N20929Heinl Christopher · Hickory, NCBuilt 1972 · S/N 18261301 N2092GUllrich Sandy J · Haskell, OKBuilt 1958 · S/N 51392 N2092SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N 21061058 N2092YNiver Michael A · Plymouth, WIBuilt 1962 · S/N 17249592 N20932Registration Pending · Hammond, LARegistration pendingBuilt 1974 · S/N 17263872 N20934Fly Skyhawk Llp · Galena, OHBuilt 1974 · S/N 17263874 N20935White Mark · Cadiz, KYBuilt 1972 · S/N 18261306 N20936Nedbalek Brent · Brenham, TXS/N 18261307 N2093BTextron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18280041 N2093GNew Herschel Dudley Jr · Savannah, GABuilt 1958 · S/N 51393 N2093YSale Reported · Agar, SDSale reportedBuilt 1962 · S/N 17249593 N20940Cirrus Flight Operations Inc · Minneapolis, MNBuilt 1974 · S/N 17263876 N20944Moody Robert L · Ava, MOFirst renewal noticeBuilt 1972 · S/N 18261313 N20945Georgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281295

Back to AD 79-10-14 R1