AD 2007-24-13
Registered aircraft · 4,026
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:2007-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:2007-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:2007-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:2007-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.
N378JHPtj Associates LLC · La Canada Flt, CAN379CDOptimal Aircraft Management Mi LLC · Sanford, MIN379SRSweetwater General Contracting LLC · Cumming, GAN37FDCirrus Design Corp · Duluth, MNN37KHKlmk LLC · Beaumont, TXN37LTValiair Lc Trustee · Casper, WYN37RDSale Reported · Mclean, VASale reportedN37THUnlimited Boat Sales Inc · Page, AZN37TMBossman Cirrus LLC · Uvalde, TXN37TSN332tt LLC · Happy Valley, ORN3800PRem Real Estate Investments LLC · Longview, TXN380CDTomlinson Consulting LLC · Columbia, MDN380CPBrady Craig · Mountain Brook, ALN380SRRegistration Pending · Casper, WYRegistration pendingN381BS381bs LLC · Fresno, CAN381CDN381cd Aviation LLC · Ventura, CAN381SWScorpion Oil & Gas LLC · Stafford, TXN382CDLakeview Aviation LLC · Middletown, DEN382DEMpt LLC · Tulsa, OKN382DJTimm David M · Napa, CAN382SRJernigan Raymond James · Scotts Valley, CAN383BSky West Aviation Inc Trustee · Albuquerque, NMN383CDAmsam Transport LLC · Mustang, OKN383CPVanclef Financial Group Inc · San Luis Obispo, CAN383JMRegistered aircraftN383SRCoscia Joseph R · Granite Bay, CAN384CAircraft Guaranty Corp Trustee · Oklahoma City, OKN384DEDestinations Efc LLC · Tulsa, OKN384SRRegistered aircraftN3851CAbb Aviation LLC · Burnsville, MNN385CFoster Harry A · Birmingham, ALN385SRMcmonigle And Associates LLC · Washington, DCN386CKRiggs Russell · Sedalia, CON386DEDestinations Efc LLC · Tulsa, OKN386RRProspective Management LLC · Ann Arbor, MIN387J387j LLC · Scotts Hill, TNN387LRWoodruff Howard G · Goodyear, AZN387SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN387TXPeterson Shawn M · Scottsdale, AZN388APSch Aviation Inc Trustee · Sporle Kings LynnN388CEKtlh Aviators LLC · Tallahassee, FLN388CPKountry Air Aviation LLC · Montgomery, INN388DEC4 Aviation LLC · Tulsa, OKN388DHCavu Pilot LLC · Powell, TNN388ELCirrus Design Corp · Duluth, MNN388GWings And Wheels II LLC · Parker, CON3891WPhoenix Construction Services Inc · Lynn Haven, FLN389DECirrus Design Corp · Duluth, MNN389MBCirrus Design Corp · Duluth, MNN389WMKairos Holdings LLC · Scottsboro, AL
Back to AD 2007-24-13