Registered aircraft · 1,235

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:2010-13-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-13-07') 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:2010-13-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-13-07')
  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:2010-13-07')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-13-07')
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.

N101CEDurocher Alain P · Long Beach, CABuilt 1982 · S/N 32R-8229066 N101TKLensing Wayne K · Popular Grove, ILBuilt 1980 · S/N 32R-8029062 N103ENKjs Development LLC · Temecula, CABuilt 1995 · S/N 4622186 N10586Cloud #9 Enterprises Inc · Mooresburg, TNS/N 4636404 N105DGFraser And Daughter LLC · Saint Augustine, FLBuilt 2024 · S/N 4636857 N105HPRyan Transportation Services Ltd · Marysville, OHBuilt 2003 · S/N 3257322 N1063CJim Johnson Nissan Inc · Bowling Green, KYBuilt 2006 · S/N 3257440 N1064SSterling Smkr3 LLC · Oklahoma City, OKBuilt 2007 · S/N 4636411 N1065DN1065d Mirage LLC · Rockville, MDBuilt 2006 · S/N 4636401 N1066BWexhler David R Trustee · Carlsbad, CABuilt 2006 · S/N 3257443 N1066SOmll Investments LLC · Ponte Vedra Beach, FLBuilt 2007 · S/N 3257457 N106LValiair Lc Trustee · Casper, WYBuilt 2000 · S/N 3257130 N1075NBlackstone Barry V · Superior, NEBuilt 2007 · S/N 4636421 N10767Kansa Development Corporation Inc · Junction City, KSBuilt 2007 · S/N 4636409 N107MCVeratix Ventures LLC · Carlsbad, CABuilt 2013 · S/N 4636609 N1087GBulzan Gary · Chardon, OHBuilt 1996 · S/N 4636150 N10DKVillage Air LLC · Wichita, KSBuilt 1999 · S/N 4636223 N110STBright Dale A · Limestone, TNBuilt 2005 · S/N 4636373 N1111MRw Air LLC · Rock Hill, SCBuilt 1982 · S/N 32R-8329010 N111DVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 4636311 N111MWSaratoga 181 LLC · Mesa, AZBuilt 2023 · S/N 4636822 N111RWNordo LLC · Kettering, OHS/N 32R-8129064 N111SXJcccs Land And Cattle LLC · Harrisburg, NEBuilt 2000 · S/N 46-36286 N1122EVasey Igor · San Francisco, CABuilt 2000 · S/N 32-57176 N112HDJackson Larry D · Orlando, FLBuilt 2000 · S/N 46-36260 N1139LMathewson Crews Aviation LLC · Indianapolis, INBuilt 1980 · S/N 32R8029091 N113BPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 4636363 N115DWMav LLC · Erie, COBuilt 2024 · S/N 4636848 N117BMManeck Aviation LLC · Columbus, GABuilt 1997 · S/N 46-36078 N117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 3257217 N117KRFox Planes LLC · Sterling Heights, MIBuilt 1997 · S/N 4636088 N117NURegistered aircraftBuilt 1998 · S/N 4636138 N118JGRopewalk Investments LLC · Wilmington, DEBuilt 1995 · S/N 4622187 N119GSDall James R Jr · Hayes, VABuilt 1985 · S/N 32R-8529009 N119WKOntop Airops LLC · Maumee, OHBuilt 2003 · S/N 4636348 N11HKJohnson Wendell F · Harlingen, TXBuilt 1981 · S/N 32R-8129071 N1202HAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2024 · S/N 4636836 N120DGBluesail LLC · Las Vegas, NVBuilt 1981 · S/N 32R-8129077 N120FWRaabe Travel LLC Series 1 · Whitehouse, TXBuilt 1998 · S/N 4636134 N120PTPi Air LLC · Malibu, CABuilt 2022 · S/N 4636797 N121REHigh Life Aviation LLC · St George, UTBuilt 2017 · S/N 4636718 N121TFTorres Juan · Modesto, CABuilt 2004 · S/N 3257351 N1224TAig Aeronautics LLC · Guaynabo, PRBuilt 1999 · S/N 32-57116 N122WDSazerac Air LLC · Bedford, NHBuilt 1997 · S/N 4636084 N123TEVirgil W Young Jr Pa · North Little Rock, ARBuilt 1994 · S/N 4622169 N124EDSecond Wind Enterprises LLC · Chamblee, GABuilt 2014 · S/N 4636642 N1258QSiner John R · Kingsport, TNBuilt 1999 · S/N 4636191 N126LMMatt Aviation Propertis Inc · Nashua, NHBuilt 2003 · S/N 3257336 N126PCRoots & Wings Aviation LLC · West Simsbury, CTBuilt 1979 · S/N 32R-8029042 N126PKPtk Equipment Inc · Miami Lakes, FLBuilt 2005 · S/N 3257390

Back to AD 2010-13-07