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.
N2431VAamodt Arne E · Soldotna, AKN2431XDvirnak Paul · Hesperus, CON2432KChristiansen Aviation LLC · Wilmington, DEN24334Sorbi Aviation Inc · El Cajon, CAN24336Moody Bible Institute Of Chicago · Spokane, WAN24337Dunn Craig M · Sarasota, FLN2433EElco Electric · Bangor, MEN2433SN2433s LLC · Manassas, VAN2433UEddleman David Baggett · Mclean, VAN2434YRegistration Pending · Cedar Falls, IARegistration pendingN24350Aero Equities LLC · Ventura, CAN24352National Training I LLC · Wilmington, DEN2435CAzure Skies LLC · Bloomington, INN2436NThunderbird Aviation · Bloomington, MNN2436VGt Holdings LLC · Nashville, TNN2436WThunderbird Aviation · Bloomington, MNFirst renewal noticeN24376C R Transport Inc · Wilmington, DEN2437LLean Enterprises Inc · Brookhaven, MSN2437WAllen Larry D · Bellingham, WAN24389Way Of The Lord LLC · London, KYN2438AHorse Creek 3518 Inc · Hollywood, FLN2438ERainier Flight Service LLC · Renton, WAN2438FMackie Scott Christopher · Elkton, MDN2438SMid-Island Air Service Inc · Ronkonkoma, NYFirst renewal noticeN2439BVan Bortel Aircraft Inc · Arlington, TXN2439C206 Aircraft Leasing Co Inc · Marathon, FLN2439DN2439d LLC · Oklahoma City, OKN2439RAdams Aviation Services Inc Trustee · Wilmington, DEN2439SBright Scott Devin · Platteville, CON2439TSkylane 2439t Partners LLC · Burlingame, CAN2439ZPlane Nonsense Inc · Middletown, DEN243AURunamuck LLC · New Orleans, LAN243CPCivil Air Patrol · Maxwell Afb, ALN243EPEpic Aviation Inc · New Smyrna Beach, FLN243HAAtp Aircraft 8 LLC · Wilmington, DEN243MCRankin John · Nokomis, FLN243MEMcaleer William V Jr · Milledgeville, GAN243RLAtp Aircraft 8 LLC · Wilmington, DEN243SPBarbers Point Flight School LLC · Kapolei, HIN2440PN2440p LLC · Seattle, WAN2440QTeanaway Ventures Consulting LLC · Cle Elum, WAN2440VVehrs Roger K · Roseburg, ORN2441DKsm Aviation Inc · Wilmington, DEN2441EMyf Holdings LLC · San Diego, CAN2441GTognoli Stefano F · Union, ORN2441XPippy LLC · Naples, FLN2441YTag Aviation LLC · Santa Teresa, NMN24429Pniak Robert J · Carmel Valley, CAN2442QCoastal Business Systems Inc · Eureka, CAN2443HSilver Star Jet LLC · Delafield, WI
Back to AD 2003-24-13