AD 2003-24-13
Registered aircraft · 7,870
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:2003-24-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:2003-24-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:2003-24-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:2003-24-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.
N1SLHotel Kilo Aviation LLC · Anchorage, AKN2000CTextron Aviation Inc · Wichita, KSN2002FTextron Aviation Inc · Wichita, KSN2004UEpic Aviation Inc · Denison, TXN20067Epic Aviation Inc · Denison, TXN2006PKnox Timothy A · Tulsa, OKN2007VCompass Rose Aviation LLC · Derby, KSN2007XEpic Aviation Inc · Denison, TXN20126Papa Whiskey Enterprises LLC · Merrimack, NHN2012FEpic Aviation Inc · Denison, TXN2012YLake Robert P · Fruita, CON20135Africair Inc · Miami, FLN2013WEpic Aviation Inc · Denison, TXN2014SGaige Gerald · Gassville, ARN2016FEpic Aviation Inc · Denison, TXN2017CHigher Flyer LLC · Northport, ALN201ELAa-Aero LLC · Lewes, DEN201FSRegistration Pending · Peoria, AZRegistration pendingN201KSKing Aircraft LLC · San Diego, CAN201THG & M Aircraft Inc · Wheat Ridge, CON201TWTom Wood Aviation Inc · Fishers, INN201WLWingsleasing LLC · Wichita, KSN2020CN2020c LLC · Abilene, TXN2027PHake Equipment Leasing LLC · Farmington Hills, MIN2028BWeber Richard · Mountain View, CAFirst renewal noticeN202AJEnterprise Aviation Services LLC · Albuquerque, NMN202BWCoastal Defense Inc · Mill Hall, PAN202CPCivil Air Patrol · Maxwell Afb, ALN202MCBeemer Companies · Fairmont, MNN202SPColorado State Patrol · Denver, CON2030CSky Bear LLC · Lakewood, CAN203CPCivil Air Patrol · Maxwell Afb, ALN203DBSky West Aviation Inc Trustee · Albuquerque, NMN203KSMichael Lichtman Inc · Oceanside, CAFirst renewal noticeN203SPColorado State Patrol · Denver, CON20401Atpce LLC · Wilmington, DEN2040HAbc Plane LLC · Freeport, TXN20412Atpce LLC · Wilmington, DEN20416Carl L Mccallister Inc · Wilmington, DEN20417Atpce LLC · Wilmington, DEN20422Atpce LLC · Wilmington, DEN20425Atpce LLC · Wilmington, DEN2044YPsalm 19:1 Aviation LLC · Annapolis, MDN2046KChristiansen Aviation LLC · Wilmington, DEN2047CPropp & Wings LLC · Missoula, MTN20489Lone Oak Properties LLC · Flagstaff, AZN2049PVan Bortel Aircraft Inc · Arlington, TXN204JHLivin The Dream Too LLC · St Paul, MNN204RSKenai Peninsula Air Transportation & Lodging LLC · Lake Havasu, AZN20502Atpce LLC · Wilmington, DE
Back to AD 2003-24-13