OpenAirDocs.org
AD 2022-13-15

Registered aircraft · 1,351

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

N1007SNmaer Inc · Orlando, FLBuilt 2007 · S/N RB-209N100CBC3 Air LLC · Wilmington, NCBuilt 2009 · S/N 525B0327N100JWBluebird Air LLC · Prospect, KYBuilt 2006 · S/N 525B0086N100PFPony Express Aviation LLC · Miami Beach, FLBuilt 2000 · S/N 525-0390N100SBA-7 Austin Aviation LLC · Amarillo, TXBuilt 2011 · S/N 525C0061N101USky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 525-0454N101WJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 525A0151N102CPSecoda Aviation 2 LLC · Muncy, PABuilt 2023 · S/N 525B0712N103CLBlue Lake Enterprises LLC · Incline Village, NVBuilt 2003 · S/N 525A0178N103DSHr Leasing LLC · Dover, DEBuilt 2005 · S/N 525B0031N103KKRf Aviation LLC · Midland, TXBuilt 2018 · S/N 525B0568N104WFRedtail Management LLC · Ocilla, GABuilt 2002 · S/N 525A0122N105ADComputer Service Professionals Inc DBA · Wilmington, DEBuilt 2010 · S/N 525C-0013N106CJCitation 525 Inc · Eugene, ORBuilt 1993 · S/N 525-0006N107PTPapa Tango LLC · Petaluma, CABuilt 2006 · S/N 525B0127N108ELucky Stars LLC · Missoula, MTBuilt 2015 · S/N 525B0476N108LAPrice Services Inc · Monticello, ARBuilt 2007 · S/N 525B0176N109APCj2 131 LLC · Milwaukee, WIBuilt 2002 · S/N 525A0131N109CCourtor Leasing LLC · Valencia, PABuilt 1981 · S/N 501-0236N109TWLegacy Jets LLC · Wilmington, DEBuilt 2010 · S/N 525B0338N10PFAqua Lift LLC · Key Largo, FLBuilt 2003 · S/N 525A0165N10TRNtr Aviation LLC · Dallas, TXBuilt 2011 · S/N 525B0354N10UTOut Aviation LLC · Fort Wayne, INBuilt 2008 · S/N 525A0407N11007Coastal Elite Air LLC · Helena, MTBuilt 1979 · S/N 501-0118N110FDYellowstone Leasing LLC · Pray, MTBuilt 2006 · S/N 525A0308N110PRCrown Air LLC · Bend, ORBuilt 2002 · S/N RB-29N110RFGyansys Equipment LLC · Carmel, INBuilt 2022 · S/N 525B0682N1127KHutter Charles G · Carson City, NVBuilt 1998 · S/N 525-0293N112GSMldw Holdings LLC · Darien, CTBuilt 2002 · S/N 525A0127N113BGWdc Equipment LLC · Webster, TXBuilt 2002 · S/N 525A0078N114WBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 525A0350N115MEGreenwing Resource LLC · Tipton, MOBuilt 2010 · S/N 525A-0464N115SMJet Aircraft 5 LLC · Wilmington, DEBuilt 2007 · S/N 525B0201N116AACorsair Two LLC · Hillsboro, ORBuilt 2007 · S/N 525B-0194N117BEvp Systems Aviation LLC · Santa Barbara, CABuilt 2018 · S/N 525B0561N1181PCi2 Holdings LLC · Carrollton, TXBuilt 2023 · S/N 525B0687N118CJHenrikson Steven R · Morristown, TNBuilt 2008 · S/N 525A0384N119CJJv Rh LLC · Birmingham, ALBuilt 2002 · S/N 525A0119N11LGLima Golf Investments LLC · Bigfork, MTBuilt 1994 · S/N 525-0066N11SGOk3 Air Leasing LLC · Heber City, UTBuilt 2019 · S/N 525B0599N11THLipsey Leasing LLC · Newark, DEBuilt 2006 · S/N 525B0056N11VHRegistered aircraftBuilt 2025 · S/N 525B0745N121DMMaisley Aviation LLC · Jasper, ORS/N 525B0500N121TSSky King Charters LLC · Cincinnati, OHBuilt 2023 · S/N 525B0692N121VMAlan Aviation LLC · Altadena, CAS/N 525-0314N1220WP2 Flight Operations LLC · Fort Worth, TXBuilt 2003 · S/N 525A0146N122ERAdvisors Aviation LLC · Saint Louis, MOBuilt 2005 · S/N 525B0030N122KHAirric LLC · Miromar Lakes, FLBuilt 2003 · S/N 525A0159N122PAPafford Medical Billing Services Inc · Hope, ARBuilt 2010 · S/N 525B0346N123CJElevation Air LLC · Miami, FLBuilt 2007 · S/N 525B0149
Back to AD 2022-13-15