Skip to content

Registered aircraft · 6,915

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.

N2168FDean William R · Webster Springs, WVBuilt 1999 · S/N 27-0261 N2168JAirgus LLC · Henderson, NVBuilt 1999 · S/N 27-0265 N216ADDiscofly LLC · Bernardsville, NJBuilt 2008 · S/N T18208833 N216CCSuncoast Nursery & Tiki Huts Inc · Homestead, FLBuilt 2016 · S/N T20609227 N216CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609138 N216DCDornink Steven R · Birchwood, WIBuilt 2000 · S/N 18280898 N216NBNby Productions · Bristow, VABuilt 2018 · S/N T20609527 N216PWPapa Whiskey LLC · Chicago, ILBuilt 2002 · S/N 3257304 N216SBMorotti John M · Las Vegas, NVBuilt 2004 · S/N T20608463 N2170WSacks Martin · Mill Valley, CABuilt 2005 · S/N T18208441 N2171BCleary Kevin W Trustee · Glendale, AZBuilt 1979 · S/N 32R-7987033 N2171QAmster Richard B · Brookline, MABuilt 1999 · S/N 27-0262 N21722Western Properties Investors And Advisors LLC · Laguna Niguel, CABuilt 2004 · S/N T18208261 N21727Centennial Corp · Reno, NVBuilt 1979 · S/N 32R-7887227 N2172BBenesh Mark L · Punta Gorda, FLBuilt 1978 · S/N 32R-7987034 N2172JTaylor A Pharr Esq LLC · Alexander City, ALBuilt 2004 · S/N T18208250 N2172WGo Around LLC · Elburn, ILBuilt 2007 · S/N T18208704 N21733Bradley Ralph W Jr · Newbury Park, CABuilt 2007 · S/N T18208706 N21744Oatdog Aviation LLC · Atlanta, GABuilt 2004 · S/N T18208255 N21746Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N T18208462 N2175ACrawford Garrett Ross · Artesia, NMBuilt 1979 · S/N 32R-7987012 N2175WIndustry Machine Design & Automation Inc · Camarillo, CABuilt 2005 · S/N T18208463 N2176LBixler David L · Lake Forest Park, WABuilt 1999 · S/N 27-0263 N2176STango-Alpha LLC · Saint Charles, MOBuilt 2004 · S/N T18208256 N2177JPlane Skies Aviation · Cedar, MNBuilt 2000 · S/N 27-0286 N21796Seegmiller Geoffrey · Houston, TXBuilt 2004 · S/N T18208329 N2179MKairez Carolyn E · Punta Gorda, FLBuilt 2005 · S/N T18208466 N217DLValiair Lc Trustee · Casper, WYS/N T20608224 N217TSLaukatel Air Inc Trustee · Wilmington, DEBuilt 1998 · S/N 4636144 N2181AL&C Ventures LLC · Clovis, NMBuilt 2005 · S/N T18208467 N21825Shepherd David K J · Bakersfield, CABuilt 1978 · S/N 32-7840189 N2182KDura Built LLC · Greensburg, KYBuilt 2005 · S/N T18208469 N2182VJavorsek Daniel II · Harriman, TNS/N 32R-7987117 N2183PBarney Northcote Inc · Riverside, CABuilt 2005 · S/N T18208470 N2183VMile High Maintanance Inc · Lakewood, COBuilt 1979 · S/N 32R-7987118 N2186ZNational Products Inc · Seattle, WABuilt 2005 · S/N T20608559 N21873Orourke Daryl J · Oak Lawn, ILBuilt 1978 · S/N 32R-7885264 N21892Dove Aviation LLC · Greensboro, GABuilt 1978 · S/N 32R-7887237 N21899Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 32R-7887239 N218AZZavaleta Eric · Abilene, TXBuilt 2008 · S/N 3257486 N218SGMg Air Ventures LLC · Tucson, AZBuilt 2017 · S/N T20609518 N2190BVeritas Aero LLC · West Lafayette, INBuilt 1978 · S/N 32R-7985014 N2191BPetersburg Flying Service LLC · Petersburg, NEBuilt 1978 · S/N 32R-7985015 N2193GWestward Aviation · Boulder, COBuilt 2000 · S/N 27-0294 N2196LAerolisse LLC · Chouteau, OKBuilt 2005 · S/N T18208478 N21971Mp Aviation LLC · Buffalo, NYBuilt 2007 · S/N T18208730 N219CSLebanon Antique Mall Tn LLC · Lebanon, TNBuilt 2020 · S/N T20609599 N219DL3 Wolfpack Sigma LLC · Overland Park, KSBuilt 1999 · S/N 4636209 N219SB155 Aviation LLC · Redwood City, CABuilt 2006 · S/N T18208598 N219SDFreund Gregor · San Francisco, CABuilt 2001 · S/N 2050

Back to AD 71-13-01 R1