Skip to content

Registered aircraft · 54,019

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

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 N2089STxt Aviation LLC · Deland, FLS/N R18201299 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 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 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 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 N20946Local News LLC · Janesville, WIBuilt 1972 · S/N 18261315 N20948Wallin Rolf B · Fayetteville, NCBuilt 1972 · S/N 18261316 N2094YHill Karl A · Visalia, CABuilt 1963 · S/N 17249594 N2094ZSpak Andrew T · Thousand Oaks, CABuilt 1963 · S/N 15059894 N20951Strevels Stephen M · Knoxville, TNBuilt 1974 · S/N 17263879 N20954Hardin John M · Terrell, TXS/N 17263881 N20955Dimich Milan C · La Jolla, CABuilt 1972 · S/N 18261320 N2095GRegistration Pending · Bozeman, MTRegistration pendingS/N 51395 N2095RTyson John H · Melba, IDS/N 18255295 N2095XMiller Michael D · Goffstown, NHBuilt 1965 · S/N 18256195 N2095YJurca John · Punta Gorda, FLBuilt 1962 · S/N 17249595 N2095ZLoose Keith · Saint Helens, ORS/N 15059895 N20962Fairmont Field LLC · Enid, OKBuilt 1972 · S/N 18261324

Back to AD 87-20-03 R2