AD 2011-26-07
Registered aircraft · 13,298
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:2011-26-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-26-07')
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:2011-26-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-26-07') 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.
N1107XHumphreys Steven Craig · Soldotna, AKN1108FAom Aircraft LLC · Wilmington, DEN1108TSale Reported · Crystal, MNSale reportedN1109MPatrick Chris J · Paris, ILN110BWAtwater David C · Pompano Beach, FLN110CARegistration Pending · Sturgis, SDRegistration pendingN110GGSkyview Aviation LLC · Tracy, CAN110MJTuggle Jason C · Liberty Hill, TXN110NPJungemann Jeff D · Brigham City, UTN110PAPostupack Peter Jr · New Cumberland, PAN110RLProctor Charles L · Alachua, FLN110RVMillspaugh John · Weatherford, OKN110SMPenhall Michael Joseph · Lake Forest, CAN110WKCirrus Design Corp · Duluth, MNN1114FRegistration Pending · Florence, SCRegistration pendingN1114HKendall John · Three Lakes, WIFirst renewal noticeN1115HSmitholum Adam O · Tok, AKN1117THimes Austin M · Wentworth, MON111ATSkymaster Stc LLC · Mena, ARN111HSMacav Flight Training LLC · Abilene, TXN111HVBga-Viation · Bennettsville, SCN111LKnuth Dale G · Hartford, SDN111MFField Monica · Los Angeles, CAN111PHGood Flight Aviation LLC · Stockton, CAN111RTJcec LLC · Washington Tr, UTN111RXThompson William · Tampa, FLN111SMMuller Aviation LLC · New Baltimore, MIN1120DCompher Charles D · Berryville, VAN1120FHaidle Wayne M · Bismarck, NDN1122FDollosso Frank G · Lakeport, CAN1122HEdge Derek Thomas · Center Barnstead, NHN1122WWittman Dennis K · La Crescenta, CAN1124HNolan Robert C II · Las Vegas, NVN1125FAeropark LLC · Michigan City, INN1125HClark David D · Nenana, AKN1127FPricemeyer Aviation LLC · St Pete Beach, FLN1128FLockridge James · Adairsville, GAN1129FKoch Bradley D · Billings, MTN1129MTechair LLC · Playa Vista, CAN112CAWickter Lawrence D Jr · Sugar Grove, ILN112NBillingsley Carl · Henderson, TXN112QBFloyd Austin · Searcy, ARN112RCStraubel Investments Inc · Egg Harbor, WIN112RPTaylor Chad A · Enid, OKN1130FMonahan William T · Vestal, NYN1131HLeisner David L · Palmer, AKN1131QFarm Country Air LLC · Jefferson, IAN1132HWallis Frederick W · Healy, AKN11337Harris Hayden H · Chelsea, MIN1133FFinnelly Barry J · Snohomish, WA
Back to AD 2011-26-07