Registered aircraft · 671

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

N648HERocket Air LLC · Carson City, NVBuilt 1997 · S/N 525-0219 N650CWTrec Investments LLC · Columbia, MOBuilt 2023 · S/N 525-1153 N651CJWpi Equipment LLC · Baker City, ORBuilt 2000 · S/N 525-0365 N654WWLvp Air LLC · Chattanooga, TNBuilt 1994 · S/N 525-0053 N655CKArrowhead Aviation Inc · Batesville, ARBuilt 2001 · S/N 525-0448 N659WGMa Monarch LLC · Phoenix, AZBuilt 2018 · S/N 525-1002 N661BPBlack Potato Express LLC · Bakersfield, CABuilt 2014 · S/N 525-0832 N665RCDouble Aught Dairy LLC · Dexter, NMBuilt 2025 · S/N 525-1192 N668EEFlying Journey LLC · El Monte, CABuilt 1999 · S/N 525-0343 N671KWKwik Wall 1 LLC · Springfield, ILBuilt 1998 · S/N 5250273 N672JMPeregrine Aviation LLC · Tallahassee, FLBuilt 2002 · S/N 525-0485 N678RTWorld Is Not Enough LLC · Turner, ORBuilt 1999 · S/N 525-0304 N67AZLazy Ta Legend Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 525-0245 N67JTIntermountain Powersports Inc · Salt Lake City, UTBuilt 2001 · S/N 525-0469 N684PSMedical Air Inc · Raleigh, NCBuilt 2016 · S/N 525-0932 N686JHHorton Aviation LLC · Tulsa, OKBuilt 2013 · S/N 525-0810 N68CHIntentional Air LLC · Brigham City, UTBuilt 2016 · S/N 525-0902 N68KKC&J Aviationllc · Wichita, KSBuilt 2017 · S/N 525-0945 N693BBBurrows Robert · Newton, WIBuilt 2026 · S/N 525-1410 N695PAPafford Air Of Mississippi LLC · Ruston, LABuilt 1996 · S/N 525-0158 N699CJSra/Rombert Aviation LLC · Miami Beach, FLBuilt 2010 · S/N 525-0699 N6NCMeadowbrook Holdings LLC · Novi, MIBuilt 1997 · S/N 525-0217 N6UBCitation525 Holdings LLC · Potomac, MDBuilt 1996 · S/N 525-0127 N700CJBruun Aircraft LLC · Portland, ORBuilt 1993 · S/N 525-0027 N700JHLittle Jet LLC · Carson City, NVBuilt 2014 · S/N 525-0828 N70APAp Global Aviation LLC · Chattanooga, TNS/N 525-0109 N70GMSeh Aviation LLC · Boaz, ALBuilt 2008 · S/N 525-0683 N70HWBas Part Sales LLC · Greeley, COBuilt 1994 · S/N 525-0070 N70LHDaf LLC · Santa Teresa, NMBuilt 2013 · S/N 525-0811 N70MZThro Flight Inc · Boca Raton, FLBuilt 2024 · S/N 525-1172 N711C525-0630 LLC · Fulton, MSBuilt 2006 · S/N 525-0630 N711HCJhbc LLC · Wilmington, DEFirst renewal noticeBuilt 1999 · S/N 525-0313 N711JBCj-M 03207 LLC · Elizabethton, TNBuilt 2017 · S/N 525-0976 N711VASilver Circuit Investments LLC · Palm Beach Gardens, FLBuilt 2026 · S/N 525-1411 N711WGCinco Aviation LLC · Hobbs, NMBuilt 2001 · S/N 525-0424 N714LMR & B Aviation LLC · Columbia, MOBuilt 2023 · S/N 525-1139 N716DJN716dj LLC · Kentwood, MIBuilt 2021 · S/N 525-1087 N717BRSemper Fi Aviation LLC · Aledo, TXBuilt 2020 · S/N 525-1055 N71FBTelling Frederick W · Port Orange, FLFirst renewal noticeBuilt 2013 · S/N 525-0812 N71SYSilver Wing At Sandpoint LLC · Torrance, CABuilt 2014 · S/N 525-0831 N720RCRosado Aviaton Inc · Scranton, PABuilt 2007 · S/N 525-0638 N722SGDt Air LLC · Eden, NCBuilt 1995 · S/N 525-0088 N723NCC&N Aviation LLC · Tucson, AZBuilt 2021 · S/N 525-1070 N725CGWest Spark & Fly LLC · Seminole, TXBuilt 2015 · S/N 525-0869 N726TMAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2001 · S/N 525-0414 N727SBEta Partners LLC · Bossier City, LABuilt 2018 · S/N 525-1006 N729WREiron Nadav Trustee · Portola Valley, CABuilt 2000 · S/N 525-0398 N72ACAlliance Service Inc · Lexington, KYBuilt 2007 · S/N 525-0643 N72BTPhenom Partners LLC · Wilmington, DEBuilt 1999 · S/N 525-0306 N72JWTitle Financial Group LLC · Blackfoot, IDBuilt 2000 · S/N 525-0406

Back to AD 2001-02-13