Skip to content

Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

N9170HWeight Steven A · Fairview Park, OHBuilt 1993 · S/N 27-0175 N9170PP&S Aviation LLC · White Rock, NMBuilt 1967 · S/N 24-4659 N9170RPage David L · Bermuda Dunes, CABuilt 1994 · S/N 27-0177 N9170XVb Inc · Show Low, AZBuilt 1989 · S/N 4622018 N9171PMckim Thomas F · Winston Salem, NCBuilt 1967 · S/N 24-4660 N91727Qualitair LLC Trustee · MichelstadtBuilt 1999 · S/N 27-0267 N9172PSale Reported · Henderson, NVSale reportedBuilt 1967 · S/N 24-4661 N91734Lejeune Walter R III · Clarksville, TNS/N 4622040 N9174NPool Aaron · Houston, TXBuilt 1989 · S/N 4622054 N9175SMarshall Adam A · Fremont, NEBuilt 1967 · S/N 24-4664 N9176GQs Aviation LLC · Laredo, TXS/N 4622055 N9176PWalter Richard · Hampshire, ILBuilt 1967 · S/N 24-4665 N9177Chaffin Christopher · Flower Mound, TXBuilt 1972 · S/N 3125 N9177PCochran Charles M III · Terre Haute, INBuilt 1967 · S/N 24-4666 N9178PCarnes Harley · Ocean, NJBuilt 1967 · S/N 24-4668 N917CFN917cf LLC · Tucson, AZBuilt 2005 · S/N T20608523 N917GTCentral Airlines Inc · Leawood, KSBuilt 1960 · S/N 500B-983-24 N917SELarson Donald C · Evanston, WYBuilt 1989 · S/N 27-0048 N9180PHughes Travis · Willow Park, TXBuilt 1967 · S/N 24-4670 N9180XInternational Air Services Inc Trustee · Carson City, NVBuilt 1989 · S/N 4622075 N9182PMonske Nicholas · Austin, TXS/N 24-4672 N9186NShrike One LLC · Deerfield Beach, FLBuilt 1972 · S/N 3131 N9187PJapundza Bob · Kokomo, INFirst renewal noticeS/N 24-4677 N9188PRogermoser Hanspeter · Summerville, SCBuilt 1967 · S/N 24-4678 N9189PThom Transport LLC · Marlette, MIBuilt 1967 · S/N 24-4680 N918ASFarley Scott S · Ellington, CTBuilt 1998 · S/N 3257029 N918CMRodriguez Eduardo Urquidi · Santa Teresa, NMBuilt 2001 · S/N T20608281 N91902Ebe Aviation LLC · Urbandale, IABuilt 1990 · S/N 4622094 N9190AAhlhorn Travis · New Braunfels, TXBuilt 1989 · S/N 32R-7887064 N9190PGreen Mark S · Ocala, FLBuilt 1967 · S/N 24-4683 N9193PDean Aaron · Norwich, NYBuilt 1967 · S/N 24-4686 N9193RLos Compadres Ranch · Premont, TXBuilt 1990 · S/N 4622098 N9195PHarstine Lucene May · Claypool, INBuilt 1967 · S/N 24-4688 N9196PHarris Michael · Pointblank, TXBuilt 1967 · S/N 24-4689 N9197PHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 24-4690 N9198PBarna George · Castleton, NYBuilt 1967 · S/N 24-4692 N9199POther Woman LLC · Gulf Shores, ALBuilt 1990 · S/N 4622107 N919BTGeorges Thomas A · Santa Teresa, NMBuilt 1997 · S/N 27-0226 N919SPGorman Kevin V · Ebensburg, PABuilt 1999 · S/N 3257113 N91AUScreaming Duck Air LLC · Houston, TXS/N 32R-8129017 N91BPF3 Aviation LLC · Summerville, SCBuilt 1977 · S/N 31-7812034 N91BRRegistration Pending · South Boston, VARegistration pendingBuilt 1965 · S/N 24-4326 N91FBAircraft Partner Holdings Inc Trustee · BerlinBuilt 2003 · S/N 3257314 N91MKMulaii LLC · Wilmington, DEBuilt 2014 · S/N 4636647 N9200PWings & Wheels Lease Of Central Nebraska LLC · Broken Bow, NEBuilt 1967 · S/N 24-4693 N9202YRomeo Aviation Ltd · Canton, OHBuilt 1983 · S/N 31P-8414004 N9205PDt Pralle Enterprise Inc · Hampton, IAS/N 24-4700 N9207PWissler John H · Tenino, WABuilt 1967 · S/N 24-4702 N9210YOswald Sean B Trustee · Reno, NVBuilt 1983 · S/N 31P-8414007 N9211PBordeleau Michael V · Bridport, VTS/N 24-4706

Back to AD 84-19-03 R1