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.
N718EREmbry-Riddle Aeronautical University Inc · Prescott, AZN718JER L Doskocil Inc · Crosby, TXN718LULiberty University Inc · Lynchburg, VAN719CGAlf Ix LLC · Chicago, ILN719CPCivil Air Patrol · Maxwell Afb, ALN719JGSkyhawk Dev Inc · Ennis, MTN719LULiberty University Inc · Lynchburg, VAN719SRob Hance Management P C · Argyle, TXN719THAuburn University · Auburn, ALN71BTriplett Gregory S · Groveland, CAN71CEMcgowan Chad · Rock Hill, SCN71DPDjp Enterprises Inc · Chandler, TXN71FCNaples Flying Club Inc · Naples, FLN71FFFf22 LLC · Scottsdale, AZN71HFHeritage Asset Leasing LLC · Ronkonkoma, NYN71HTAerodynamic LLC · Aurora, ORN71JFNigro Air LLC · Las Vegas, NVN71PLRegistered aircraftN71VBStephen Holtzman Consulting LLC · San Luis Obispo, CAN7207BThomas Conners · Melbourne Beach, FLN720CAAero Equities LLC · Oxnard, CAN720CPCivil Air Patrol · Maxwell Afb, ALN720LULiberty University Inc · Lynchburg, VAN720RKLong Philip Charles · Ojai, CAN721AREagle Wings Holdings LLC · Greenwood, INN721CTChristiansen Aviation LLC · Wilmington, DEN721EREmbry-Riddle Aeronautical University Inc · Prescott, AZN721FLSilver Creek Aviation Services · Fort Worth, TXFirst renewal noticeN721JJNo More Bites LLC · Alexandria, VAN721LULiberty University · Lynchburg, VAN721SACommonwealth Of Massachusetts · Bridgewater, MAN721THAtp Aircraft 7 LLC · Wilmington, DEN721WWLmg - Rba LLC · Uhland, TXN721ZASky-Vu Flyers Inc · Fishers, INN722CPFalcon 118 Denver LLC · Tiburon, CAN722CZThree D Adventures LLC · Newfolden, MNN722DMU S Wire Manufacturers Inc · Redwood City, CAN722EFEpic Aviation Inc · New Smyrna Beach, FLN722HGAmeriflyers Of Florida LLC · Addison, TXN722LULiberty University Inc · Lynchburg, VAN722MAK2 Aviation LLC · Greenwood Village, CON722PWRamsey Asphalt Construction Corp · Santa Maria, CAN722SAElmendorf Afb · Elmendorf Afb, AKN722SEBlair Management Holdings LLC · Durango, CON723CATextron Aviation Inc · Wichita, KSN723DJCesnik John A · Menomonie, WIN723HGFlight Operations Aircraft LLC · Wilmington, DEN723LULiberty University Inc · Lynchburg, VAN723MDTextron Aviation Inc · Wichita, KSN723PGPoplar Grove Airmotive Inc · Poplar Grove, IL
Back to AD 2003-24-13