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.
N712RJHigh Romance LLC · Belvedere, CAN712SPAmeriflyers Of Texas Inc · Addison, TXN7139DBenjamin Ralph L · Fitchburg, WIN7139XBryk Steven L · Port Orange, FLN713CPCivil Air Patrol · Maxwell Afb, ALN713FSTfs Air LLC · Loveland, CON713JHMccauley James · Ithaca, NYN713LULiberty University School Of Aeronautics · Lynchburg, VAN713PMWestbank Fishing LLC · New Orleans, LAN713RBKay Timothy A · Kyle, TXN713SATextron Aviation Inc · Wichita, KSN713SZN713sz LLC · Jacksonville, FLN713TRed Rock Airventures LLC · Moab, UTN7141CLongview Iron LLC · Longview, TXN7142RWirick Neil · Cable, OHN7148QRosevelt Jane · Lake Oswego, ORN714HWNational Training 1 LLC · Wilmington, DEN714LULiberty University Inc · Lynchburg, VAN714SCJuliet Charlie Aviation LLC · Oregon City, ORN7155NQualitair LLC Trustee · MichelstadtN7157BOwyhee Aviation LLC · Provo, UTN715BWBridgewater State University · Bridgewater, MAN715CPCivil Air Patrol · Maxwell Afb, ALN715DFAerospace Trust Management LLC Trustee · Wilmington, DEN715HPOhio Department Of Public Safety · Columbus, OHN715LULiberty University Inc · Lynchburg, VAN715MTSaz Dynamics LLC · Daly City, CAN715RCEide David B · Saint Michael, MNN715WMBgi Aircraft Management LLC · Alpharetta, GAN716CPCivil Air Patrol · Maxwell Afb, ALN716EPEpic Flight Academy Inc · New Smyrna Beach, FLN716HPState Of Ohio · Columbus, OHN716LULiberty University · Lynchburg, VAN716MCWing & A Prayer LLC · Wilmington, DEN716MTColvin Mariann · Round Rock, TXN716MWDirty Side Down Aviaton LLC · Georgetown, TXN716PCPcfo Air LLC · Plymouth, MNN716SCJuliet Charlie Aviation LLC · Oregon City, ORN716SPExec 1 Aviation II LLC · Ankeny, IAN716THFairmont State University · Fairmont, WVN71755Jet Air Inc · Iowa City, IAN717CPCivil Air Patrol · Montgomery, ALN717FGRidgeline Assets LLC · Wilmington, DEN717KWCollins Jeff · Portland, TNN717LULiberty University Inc · Lynchburg, VAN717MZMaritz Paul · Mercer Island, WAN717THOhio State University · Columbus, OHN7187RFlying Roaches LLC · Dallas, TXN718CPCivil Air Patrol · Maxwell Afb, ALN718EHChristiansen Aviation LLC · Wilmington, DE
Back to AD 2003-24-13