Registered aircraft · 380

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

N100RGN100rg LLC · Itta Bena, MSBuilt 2005 · S/N E-3641 N101PTN28179 Inc · West Gilgo Beach, NYBuilt 2018 · S/N E-4113 N10CABrunson Richard P · New Braunfels, TXBuilt 2007 · S/N E-3814 N112BBNethery Cattle Co LLC · Fort Worth, TXBuilt 2018 · S/N E-4112 N112EReed Gaylon R · Breckenridge, TXBuilt 2012 · S/N E-3980 N112KDCloud Surfing LLC · Mesa, AZBuilt 2016 · S/N E-4076 N11KGErickson Marine Aircraft LLC · Sarasota, FLBuilt 2012 · S/N E-3981 N127BZFox Systems Inc · Calhoun, GABuilt 2019 · S/N E-4127 N1284PTwostars Aviation LLC · New York, NYBuilt 2013 · S/N E-3988 N128CLSecond Delaware Corp · Wilmington, DES/N E-3661 N128WBWoolard Katherine B Trustee · Greenbrae, CAS/N E-3662 N129BETextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2019 · S/N E-4129 N12HJWoods Timothy J · Demarest, NJBuilt 2013 · S/N E-3990 N12PVShoreline Assets LLC · Ashland, ORBuilt 2007 · S/N E-3799 N134BBOcean Air Jet LLC · Cooper City, FLBuilt 2020 · S/N E-4134 N136HBSoaring With Steve LLC · Papillion, NEBuilt 2013 · S/N E-3987 N136JLRedline Aviation LLC · Madison, MSBuilt 2009 · S/N E-3891 N136RKAero-Springs LLC · Ocean Springs, MSBuilt 2015 · S/N E-4069 N136RRGlye David W · Prospect, KYBuilt 2007 · S/N E-3760 N136SKKottman Steven A · Anaheim, CABuilt 2014 · S/N E-4033 N137BFJetstream Ventures LLC · Polson, MTBuilt 2013 · S/N E-3999 N13JEBroach Kenneth · Bryan, TXBuilt 2013 · S/N E-4003 N140BBMothership Enterprises LLC · Homestead, FLBuilt 2020 · S/N E-4140 N142BJArrowhead Air Inc · Huntsville, TXS/N E-3713 N1436AWhitney Richard T Trustee · Steamboat Springs, COBuilt 2008 · S/N E-3856 N143WHSky High Gelato LLC · St Petersburg, FLBuilt 2006 · S/N E-3708 N151NPContrails II Inc · Wilmington, DEBuilt 2017 · S/N E-4106 N152BZTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2023 · S/N E-4152 N15AEWampler Jeffrey A · Valparaiso, INBuilt 2006 · S/N E3740 N15HCMvp60 Fly High LLC · Boca Raton, FLBuilt 2014 · S/N E-4032 N15HSF S Enterprises LLC · Oakland Park, FLBuilt 2020 · S/N E-4143 N15RHRansdell Thomas R · Boerne, TXBuilt 2010 · S/N E-3942 N16MNLittle Dixie Construction Co LLC · Columbia, MOS/N E3658 N170RCCbp Air Logistics LLC · Statham, GABuilt 2008 · S/N E-3829 N179AKCrp Research LLC · Fenton, MIBuilt 2017 · S/N E-4101 N17JKCobb Henry Hammond IV · Montgomery, ALBuilt 2008 · S/N E-3886 N17LVMountain Cascade Inc · Livermore, CABuilt 2015 · S/N E-4062 N17WZJuanje Air LLC · Newtown Square, PABuilt 2013 · S/N E-3983 N187JSzm LLC · Laconia, NHBuilt 2010 · S/N E-3925 N189LESwt Aviation Inc · Newport Beach, CABuilt 2011 · S/N E-3957 N18EJPelizzon David R Trustee · Naples, FLBuilt 2007 · S/N E-3803 N1988WAerobat Ventures LLC · Phoenix, AZBuilt 2018 · S/N E-4118 N19ATEastside Transporation LLC · Chowchilla, CABuilt 2009 · S/N E-3900 N1TZHundredaire LLC · Wichita, KSBuilt 2008 · S/N E-3830 N1WXRegistered aircraftBuilt 2022 · S/N E-4148 N20VPGoby Air LLC · Howell, MIBuilt 2014 · S/N E-4025 N217TWDonuts Aviation LLC · Atlanta, GABuilt 2007 · S/N E-3757 N222GLGarmin International Inc · Olathe, KSBuilt 2007 · S/N E-3763 N224RGBonanza Aircraft Inc Trustee · Cheyenne, WYBuilt 2009 · S/N E-3894 N226RPGlory Fly LLC · Waxhaw, NCBuilt 2018 · S/N E-4114

Back to AD 2009-15-01