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.
N379GPGreat Pacific Aviation Services Inc · Grants Pass, ORN379MATurtle With Wings LLC · Yukon, OKN379SAAerofeather Aviation Inc · Suffolk, VAN379TAChuck Smith Aircraft Inc · Torrance, CAN37CJFly172s LLC · Peoria, AZN37GGAvco Patrol LLC · Lyndon, KSN37HDJohnston-Matejek Aviation LLC · Houston, TXN37JAFlying Start Aero Services LLC · Reno, NVN37JFNexga Aircraft Inc · Greensboro, NCN37MTBeaver Valley Flying Club Inc · Beaver Falls, PAN37SDAb Prop Plane II LLC · Metairie, LAN37SEPacific Northwest Aircraft Leasing Inc · Meridian, IDN380CVCivil Air Patrol · Maxwell Afb, ALN380ESZak William Roy Jr · Kissimmee, FLN380MA75 East Air LLC · Valparaiso, INN380MEVpc Air Inc · Cartersville, GAN3810Nerio Antonio · Eagle Pass, TXN381CPCivil Air Patrol · Maxwell Afb, ALN381ESFixed Wing Holding Co Inc · Pembroke Pines, FLN382AFState Of Louisiana · Baton Rouge, LAN382CVCivil Air Patrol · Maxwell Afb, ALN382JSDap Aviation Ventures LLC · Missoula, MTN383DCDyncorp International Inc · Mcclellan, CAN383KDT-6 LLC · Wilmington, DEN383MEParlu Ventures LLC · Eagles Mere, PAN383SPKv Helicopters LLC · Lititz, PAN383TCSpengler Raymond Francis Jr · Longview, TXN384EAMatisoff Noah · Helena, MTN384JVan Bortel Aircraft Inc · Arlington, TXN384MCAero-Tech Services Inc · Lancaster, PAN384MESj Flyers LLC · San Jose, CAN3852BGromley Kevin M · Farmington, MIN385CSCosmos Holdings Group LLC · Newark, DEN385DCDyncorp International Inc · Mcclellan, CAN385KLIasco Flight Training Inc · Redding, CAN385MAPesek Larry Paul · Steinhatchee, FLN385RBNational Aircraft Leasing Corp · Greenville, DEN385TCLiebl Holdings LLC · Claremore, OKN386CPCivil Air Patrol · Maxwell Afb, ALN386EPEpic Aviation Inc · New Smyrna Beach, FLN386ESJet Air Inc · Iowa City, IAN386MEHillsboro Aero Academy LLC · Hillsboro, ORN386SPUsaf Academy Aero Club · Usaf Academy, CON387AFCsa Aircraft Leasing LLC · Salt Lake City, UTN387CSDa Aviation LLC · Englewood, CON387DCDyncorp International Inc · Mcclellan, CAN387MAAzul Services LLC · Bozeman, MTN387SPMsb Aviation LLC · Rockvale, TNN387TCBass Joel W · Okeechobee, FLN388UTFree Bird Air LLC · La Crosse, WI
Back to AD 2003-24-13