Skip to content

Registered aircraft · 6,916

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

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 N918EEArchaeopteryx LLC · Harvey, LABuilt 2022 · S/N T20609708 N918KGGreasewood Ranch Aviation LLC · Midland, TXBuilt 2006 · S/N T20608637 N918RGG & L Equipment Leasing LLC · Natchez, MSBuilt 2006 · S/N T20608682 N918ZTMs Air LLC · Hickory, NCBuilt 2008 · S/N 4692015 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 N9195BSouthwest Aviation Enterprises · Haslet, TXBuilt 2015 · S/N T20609195 N9195PHarstine Lucene May · Claypool, INBuilt 1967 · S/N 24-4688 N9196PHarris Michael · Pointblank, TXBuilt 1967 · S/N 24-4689 N9197MGlover Carl A · Albuquerque, NMBuilt 2006 · S/N T20608675 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 N919CWGv Air Inc · Medford, ORBuilt 2006 · S/N T20608619 N919SPGorman Kevin V · Ebensburg, PABuilt 1999 · S/N 3257113 N919WCCarroll Walter · Villa Hills, KYBuilt 2019 · S/N T20609580 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 N91CSSkye Furniture Inc T/A Sky Aviation · Mechanicsville, VABuilt 2023 · S/N T20609755 N91CYVan Bortel Aircraft Inc · Arlington, TXBuilt 2023 · S/N T18209102 N91FBAircraft Partner Holdings Inc Trustee · BerlinBuilt 2003 · S/N 3257314 N91FRJanie Air Inc · Roseville, CABuilt 2008 · S/N T18208859 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 N920CS R Plumbing LLC · Orlando, FLBuilt 2014 · S/N 4636638 N920CYAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2015 · S/N T20609202 N920DBColumbia Richard M · Pensacola, FLBuilt 2013 · S/N 4636608 N920XStreamline Aviation LLC · Battlefield, MOBuilt 2014 · S/N 4692206 N9210YOswald Sean B Trustee · Reno, NVBuilt 1983 · S/N 31P-8414007 N9211PBordeleau Michael V · Bridport, VTS/N 24-4706 N9212PHapka Leon J · Halma, MNFirst renewal noticeBuilt 1967 · S/N 24-4707 N9212YS & B Foundation Air LLC · Auburn, ALBuilt 1983 · S/N 31P-8414008 N9214HJem Aviation Ltd · Wilmington, DEBuilt 1990 · S/N 4622114 N9215YAstro Star Aviation Inc · Niles, MIBuilt 1968 · S/N 31-279 N9216PWilliams Dayre · Red Cloud, NEBuilt 1967 · S/N 24-4712

Back to AD 71-13-01 R1