OpenAirDocs.org
AD 2008-14-13

Registered aircraft · 5,659

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
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:2008-14-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:2008-14-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.

N106CDAerou LLC · Oviedo, FLBuilt 2000 · S/N 1015N106EZDannemann Kevin · Wallkill, NYBuilt 2006 · S/N 2044N106LUBluewater Plumbing Service LLC · Wilmington, NCBuilt 2005 · S/N 1501N106MUMarshall University · Huntington, WVBuilt 2021 · S/N 2682N106TJN106tj LLC · Murray, UTBuilt 2010 · S/N 3592N106TQRogers Scott · Asheville, NCBuilt 2007 · S/N 2633N107AJAltitude Aviation LLC · West Point, GABuilt 2007 · S/N 2671N107BCCjw Aviation LLC · San Antonio, TXS/N 3057N107CBR&Dsl Corp Trustee · Wilmington, DEBuilt 2008 · S/N 3244N107CDKhalil Hassan · Clarks Summit, PABuilt 2000 · S/N 1018N107MTTuch Michael · Gonzales, TXS/N 4846N107MUMarshall University · Huntington, WVBuilt 2021 · S/N 2784N107PBAntler Air LLC · Klamath Falls, ORBuilt 2006 · S/N 2292N107TQSouthland Air Holdings LLC · Albany, GABuilt 2013 · S/N 3996N1086CTeare Matthew A · Sagamore Hills, OHBuilt 2003 · S/N 0462N108EZGraybull Aviation LLC · Lake Orion, MIBuilt 2006 · S/N 2037N108GPCoral Desert LLC · Andalusia, ALBuilt 2005 · S/N 1317N108MGSr20 Holdings LLC · Coral Springs, FLBuilt 2023 · S/N 9431N1098RSweat Kristie S · Buford, GABuilt 2021 · S/N 5010N109FTCisco Aero LLC · Cisco, TXBuilt 2006 · S/N 2025N109MPCirrus Design Corp · Duluth, MNS/N 11905N109WKEast Bay Trading Co · Fairview, PABuilt 2004 · S/N 1400N10BXCleary James A · Fairfield Township, OHBuilt 2021 · S/N 5003N10MCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1084N10RAOne Six Bravo LLC · Kernersville, NCBuilt 2021 · S/N 5069N10UWHorton Raymond Trustee · Phoenix, AZBuilt 2025 · S/N 11054N10ZWBurnett Wade C · Sandpoint, IDBuilt 2001 · S/N 0055N1108TSale Reported · Crystal, MNSale reportedBuilt 2011 · S/N 2114N110BWAtwater David C · Pompano Beach, FLS/N 1538N110FLMac Air Aviation LLC · Xenia, OHBuilt 2007 · S/N 2813N110GKJaws Aviation LLC · Ridgeland, MSBuilt 2017 · S/N 4508N110TAHuntress Aviation LLC · Paradise Valley, AZS/N 2015N110WFValiair Limited Co Trustee · Casper, WYBuilt 2007 · S/N 2621N110WKCirrus Design Corp · Duluth, MNBuilt 2011 · S/N 2115N1119CAbc Transportation Co Inc · Bismarck, NDBuilt 2003 · S/N 0487N111DUAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2008 · S/N 3138N111ETWings And Wheels II LLC · Parker, COBuilt 2008 · S/N 3270N111HTRegistered aircraftBuilt 2002 · S/N 0232N111MUSag Phoenix LLC · Sagaponack, NYBuilt 2026 · S/N 11397N111NEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2784N111RTJcec LLC · Washington Tr, UTBuilt 2001 · S/N 1156N111TTLand Of Lincoln Aviators LLC · Chicago, ILBuilt 2004 · S/N 0830N1123XBeacon International Inc · Dover, DES/N 1214N1127RSwan Aviation LLC · Columbia Heights, MNBuilt 2005 · S/N 1510N112CDRustam Ali Wings Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11457N112SKCirrus Sr22 4821 Inc Trustee · Wilmington, DEBuilt 2019 · S/N 4821N112TRBagdasarian Walter DBA · El Cajon, CABuilt 2010 · S/N 3669N113BBN113bb LLC · Jamul, CABuilt 2021 · S/N 2722N113DSG D S Aviation LLC · Gatlinburg, TNBuilt 2020 · S/N 4977N113EDAlready Aviation LLC · Chattanooga, TNBuilt 2018 · S/N 4620
Back to AD 2008-14-13