AD 2002-26-03
Registered aircraft · 1,879
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-26-03')
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-26-03')
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-26-03') 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-26-03') 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.
N1194QKirkpatrick Jason · Mosca, CON1199ULansford Inc · Clovis, NMN11APAp Aero LLC · Oklahoma City, OKN11KRDawson Gray N · Roseburg, ORN11TCShiver James B Jr · Stanley, NMN1215MBieber Dale E · Coralville, IAN121JRKlotz Geoffrey B · Moor Park, CAN121RJCessna 121 Rj LLC · Terra Bella, CAN122RCCurtis Alvis Jr · Bakersfield, CAN1237MJ&C Walker Aviation LLC · Henderson, TXN123DDCenturion 123 LLC · Glenwood Springs, CON123DMJacquin Philip Fink · New York, NYN123JTGraham Richard A · Wichita Falls, TXN123MCNelson Isaac · Saint Croix Falls, WIN123VRLewis Edward M · Mesquite, NVN124WHHillcrest Aircraft Co Inc · Lewiston, IDN125BMBaron Transporation Services LLC · Destrehan, LAFirst renewal noticeN1289UKavak Air Inc · Middletown, DEN129ELTrooien-Smith Construction LLC · Seeley Lake, MTN12DUWoodtick Summit Aviation LLC · Redmond, ORN12PFRucker Gary R · Kingman, AZN12WDHamburg Jeffrey · Corsica, SDN1301LFox Aircraft LLC · Bethel, AKN131TTCharlie Kilo Enterprises Inc · Melbourne, FLN1331MRegistered aircraftN139BBTrejo Nahomy · Socorro, TXN13KSNolt Ivan · Mount Solon, VAN13TNMcdaniel Robert M · Tonasket, WAN1410URuffcorn Aviation Co · Bettondorf, IAN141DMTurbo Inc · Flint, MIN144WPDresel Av LLC · Fayetteville, ARN1450CFreeland Christopher G · Brownwood, TXN147TXTexas Department Of Transportation · Austin, TXN1494CFour C'S Equipment Leasing LLC · Fresno, CAN14JEN14je LLC · White Springs, FLN14NNAms Aviation LLC · South Bend, INN150SCAnderson Thomas R · Seattle, WAN151MTIsland Mountain Aviation LLC · Vesta, MNN1545GSaltzer Eric R · Somerton, AZN155DGJuliet Tango Flying Services LLC · Walnut Creek, CAN155DVDunning Vineyards · Haines, ORN155RCClark 155 LLC · Missoula, MTN1576MSkyline Aviation Services LLC · Miramar, FLN15DACamborne USA LLC · Collierville, TNN15MLN15ml LLC · Cresskill, NJN15MWZeezee LLC · Phoenix, AZN15USFlypower Inc · Fort Lauderdale, FLN1600XLd&B LLC · Show Low, AZN1605MSelter Eric Jay Trustee · Agoura Hills, CAN1615XBvi Aviation LLC · Wilmington, DE
Back to AD 2002-26-03