AD 2011-06-10
Registered aircraft · 998
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-06-10')
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-06-10')
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-06-10') 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-06-10') 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.
N350XTCentury Skyhawk Inc Trustee · Wilmington, DEN351PMValiair Limited Company Trustee · Casper, WYN351WTFree Bird Air LLC · Raymond, NEN352CMSky West Aviation Inc Trustee · Albuquerque, NMN352HAIcs Air LLC · Saint James, MNN354RVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN355CVertx Fleet Holdings LLC · San Diego, CAN355DCRyan John T · Salina, KSN357CSN357c5 LLC · Clinton, MON357MMClark Melvin G · Sunnyvale, TXN358WAWestern Aircraft Inc · Boise, IDN359STN921rt LLC · Lithia, FLN359VMAdams Aviation Services Inc Trustee · Wilmington, DEN35CMHorseshoe Air LLC · Fairfield, TXN35GGWilforge LLC · Phoenix, AZN35GHPiper Aircraft Inc · Vero Beach, FLN35KLR Ken Lord Md Pc · St George, UTN362MAPiper Aircraft Inc · Vero Beach, FLN363MMChicola Monty · Alexandria, LAN364STFlight Following LLC · Fayetteville, GAN369STAero-Mobil Inc · Wilmington, DEN36CCjd Aviation LLC · Essex, CTN36CBAopak Inc Trustee · Wilmington, DEN36RECiconia Aeronautics LLC · Madison, MSN372DGWild Air LLC · Exeter, CAN3737Qualitair LLC · MichelstadtN374KCHostetter Swinea Aviation LLC · Dickson, TNN374WFT2 Aviation LLC · Pahrump, NVN377HCHigh Altitude Aviation LLC · High Point, NCN377STNewman Aviation Services Inc · Tiffin, OHN378NSHinshaw Jerrold T · Baltimore, MDN379PVisionary Holdings LLC · Missoula, MTN37BEZortair LLC · Austin, TXN37DAW & S Aviation LLC · Pikeville, KYN37PMRegistered aircraftN37RTPlane Fun Inc Tr Trustee · Snellville, GAN37VMVictory Maximus LLC · Dublin, OHN383SA86 Malibu LLC · Fort Worth, TXN385RAdvanced Technology Distributors Inc · Ceres, CAN386STWwc Sky Holdings LLC · Wilmington, DEN389AJAloe Jaumave USA LLC · Mcallen, TXN389PCN1543t LLC · Buffalo, NYN389STSouthgroup Aviation LLC · Oxford, MSN3935YShewchuk Bailey · KelownaN3946MPlane Flt LLC · Broken Arrow, OKN394MMN654nm LLC · Centreville, VAN395PMBare Bones Aircraft Inc · Fort Walton Beach, FLN3975CMontana Aircraft Trust Inc Trustee · Bozeman, MTN397PMAircraft 445 LLC · Porterville, CAN398PMN398pm LLC · Atlanta, GA
Back to AD 2011-06-10