AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N22MMAerospace Quality LLC · Piggott, ARN22NLD2k Aviation LLC · Boyden, IAN22NVSweeney James A III · Seven Hills, OHN22PALubo Aviation LLC · Gastonia, NCN22QQSkywest Leasing Inc · St George, UTN22QTAlameda Aero Club · Alameda, CAN22RSulphur Creek Helicopters LLC · George West, TXN22RNTre Ventures LLC · Mount Olive, NCN22RSLechner Douglas K · Needham, INN22SJWright James M · San Diego, CAN22SXChase Jack L · Buxton, MEN22SYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN22SZBunn Rosemary J Trustee · Salina, KSN22TAWoodling Jason D · Venice, FLN22TFBettendorf Elizabeth J · Salem, ORN22TJFerraro Thomas P · Mckinney, TXN22TKGreen Theodore G · Franklin, WIN22UTMomentum Foundation · Tullahoma, TNN22VTMcmath Robert Roy · Seeley Lake, MTN22WDEhrler Ryan R · Spokane, WAN22WJJabour William J · Port Orange, FLN22WWMouse Air LLC · Hilton Head Island, SCN22XSSuell Tommy R · North Las Vegas, NVN22ZECoats James Michael · Murrieta, CAN22ZHBrookway Aviation LLC · Brookhaven, MSN22ZZTreicher Peter · East Aurora, NYFirst renewal noticeN2300BGoodox LLC · Garden Plain, KSN2301QFarm West LLC · Missoula, MTN2302YMustang Sally Aviation LLC · Camden, SCN2308PRubbert Randy C · Reynolds, NDN2308TBugarchich Christopher Z · Stratford, CTN2309NEaa Aviation Foundation Inc · Oshkosh, WIN230APOak View Capital LLC · Brookhaven, MSN230ASN230as LLC · Wilmington, DEN230CKKurella Charles James · Beaver Falls, PAN230DHHarris Dwain L · Pickens, SCN230DMGillespie Flying Services LLC · Trenton, SCN230EPEpic Aviation Inc · New Smyrna Beach, FLN230JCN230jc Inc Trustee · Wilmington, DEN230KGAlf Ix LLC · Chicago, ILN230MAParker-Omalley Corp · Chatham, NYN230PKGyger Keith J · Granbury, TXN230SAStature Aviation LLC · Addison, TXN230SBSierra Bravo Partnership · Liberal, KSN230SFWaters Robert · Albuquerque, NMN230SUBoelte Aviation LLC · Wilmington, DEN230TDDickerson Timothy J · Woodlake, CAN230UBoard Of Regents · Norman, OKN230WChandler Charles G · Luray, VAN230WCKeiser John T · Santa Fe, NM
Back to AD 2006-10-21