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.
N11HYSpa Aero LLC · Helena, MTN11JCWahlin Donald D · Stoughton, WIN11JUPottorff Gregory K · Wayne City, ILN11JVHoltz Jeff · Liberty Lake, WAN11KAlbers Edward C · Burlington Flats, NYN11KCCunningham Kevin M · Alexandria, MNN11KPHoward William T · North Fort Myers, FLN11KXN11kx LLC · Santa Clara, CAN11KZHigh Tale LLC · Saint Anthony, IDN11LJHandyquick Mn LLC · Woodbury, MNN11LKPhillips Scott · Chandler, AZN11LRRuth Lawrence J · Roselle, ILN11LTG T Flying Club LLC · Bellaire, TXN11LYBishop Jay K · Columbus, INN11MCSchwenk Alan G · Tolono, ILN11MHSellmeyer Scott M · Wichita, KSN11MPAtwill Brock · Paragould, ARN11MTSpeedy Aviation LLC · Liberty, SCN11NInternational Air Services Inc Trustee · Carson City, NVN11NTSabb Anthony · Wetumpka, ALN11PJSwift Ralph Jr S · Lebanon, TNN11PZCentral Virginia Flyers LLC · Palmyra, VAN11RAMonkey Biziness LLC · Cherryville, NCN11RWSimonye Curtis F · Holmes Beach, FLN11RYMsk Air Transport LLC · Mankato, MNN11SCHarrington John M · Payson, AZN11TDDuflo Spray Chemical Inc · Lowville, NYN11TLLoofbourrow Travis S · Houston, TXN11TPTienken Henry N · Newton, NJN11TUJessup Rob L · Carson City, NVN11UGBrandemuehl Joseph J · Boscobel, WIN11UTMax Aviation LLC · Venice, FLN11UZEastern Stearman Inc Trustee · Leesburg, VAN11VCNgo Lam · Cary, NCN11VNHilton Head Flyers LLC · Liberty, SCN11VXOwens Randy · Washington, UTN11XYBach Scott H · Yakima, WAN11XZJordan Shawn B · Scottsdale, AZN11YMSetzer Ted · Granite Falls, WAN11YTAnm Air LLC · Grimes, IAN11ZARanch Aero LLC · Sterling City, TXN11ZDQualitair LLC Trustee · MichelstadtN11ZMJr Aircraft Services LLC · Oxford, MIN11ZVWebb Group Flp · Jackson, MSN1200VTampa Bay Aviation Inc · Clearwater, FLN1200XLacola Joseph D · Commerce Township, MIN1201EN1201e LLC · Wilmington, DEN1201JHall Brian E · Bedford, INN1201SFlying J Ranch Of Ocala Inc · Port Saint Lucie, FLN1201TTrudel Serge · The Woodlands, TX
Back to AD 2006-10-21