AD 2002-23-13
Registered aircraft · 3,462
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:2002-23-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:2002-23-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:2002-23-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:2002-23-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.
N90EHPilot Precision Products LLC · South Deerfield, MAN90HGIntermountain Medical Transport LLC · Salt Lake City, UTN90JXDean Lumber Co Inc · Gilmer, TXN90KOenovation LLC · Saint Helena, CAN90LYRegistered aircraftN90NCDodson International Parts Inc · Rantoul, KSN90PHTriple R Spraying LLC · Dumas, TXN90PRSfclh LLC · Yukon, OKN90UAUniversal Avionics Systems Corp · Tucson, AZN90WFSomers-Lawson Land & Cattle LLC · Midland, TXN90WJDodson International Parts Inc · Rantoul, KSN90YBRmb Leasing Inc · Dover, DEN90ZZMckeand Scott · Grant Township, MIN9100ZExpress Industries LLC · Prescott Valley, AZN91092Wakefield Aircraft LLC · Cooperstown, NDN910ECState Of Tennessee Department Of Transportation · Nashville, TNN910EHGuardian Flight LLC · Lewisville, TXN910FEFederal Express Corporation · Memphis, TNN9115XPiper Aircraft Inc · Vero Beach, FLN9119BWoodley Aerial Leasing LLC · Walnut, ILN911CFCustom Flight Rnh LLC · New Richmond, WIN911HWRogers Helicopters Inc · Fresno, CAN911KADavis Aviation DBA · Brandon, MSN911KQSecret Squirrel Aerospace LLC · Tampa, FLN911KWRogers Helicopters Inc · Fresno, CAN911NPVelocity Sport LLC · Waterloo, IAN911RLDale Aviation Inc · Rapid City, SDN911RNDixie Air Applicators LLC · Itta Bena, MSN911SFReiner Russell · Redding, CAN911TCMorcomb LLC · Bonita Springs, FLN911VMGuardian Flight LLC · Lewisville, TXN911VRRogers Helicopters Inc · Fresno, CAN9121PFarm Air Service Inc · Tallulah, LAN9122ZIntermountain Helicopter Inc · Sonora, CAN9124FCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN91262Busby James D II · Port Saint Lucie, FLN91266Air Dusters Inc · Roggen, CON9129ZAir-Trac Inc · Pasco, WAN912FEFederal Express Corp · Memphis, TNN912SVSaint Vincents Healthcare · Billings, MTN9134ARosewood Air LLC · Plaucheville, LAN91357Wilde Air Service LLC · Volga, SDN91358Kubecka Daniel P · Edna, TXN9135FRba LLC · Kimberly, IDN9136ULewis Flying Maintenance Service · Morse, LAN91398Tri-Air Farms LLC · Mamou, LAN913NMSan Juan Regional Medical Center Inc · Farmington, NMN913RXReach Air Medical Services LLC · Santa Rosa, CAN9143FStove Creek Air LLC · Unadilla, NEN914ASRed Speakers LLC · Newark, DE
Back to AD 2002-23-13