AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N355DCRyan John T · Salina, KSN355GKAircraft Holding And Leasing LLC · Sarasota, FLN355LTLt Group Holdings LLC · Newark, DEN355MJHaldeman Richard C · Frisco, TXN355MWCotton Aviation Enterprises Inc · Lakeway, TXN355NEMeyers Air Service LLC · Superior, NEN355PGLips78 LLC · Windermere, FLN355SAReddy James N Trustee · Port Orange, FLN355SCSmith Loren D · Great Falls, MTN355TBravo Busters LLC · Kalispell, MTN355TFCirrus Design Corp · Duluth, MNN355TGHigh & Fast LLC · Batesville, ARN355WTSerious Business LLC · Gregory, SDN355YPlussa Mark George · Clermont, FLN356Endless Sky LLC · Temple, GAN3565JKendrick Ross Mitchell · Sycamore, GAN3566WGriffin Aviation LLC · Minneapolis, MNN356CAWest Road LLC · Whiting, VTN356DK1 Grand Rotorsport LLC · Princeton, WVN356LEFly Pharmd LLC · Valdosta, GAN356RKMec2 Aviation LLC · Catonsville, MDN356SCHogge Steven D Trustee · Colfax, CAN356TTMercator Aviation LLC · Orlando, FLN357AFour Leaf Air LLC · Cedar, MIN357BDCoventry Air LLC · Parker, CON357BMBargfrede Bernard Trustee · Blackburn, MON357CSN357c5 LLC · Clinton, MON357GKGk Aviation LLC · Orlando, FLN357JR24 Air LLC · Orlando, FLN357JTClub Bo A36 LLC · Helena, MTN357MMClark Melvin G · Sunnyvale, TXN357PGEike Properties LLC · Portland, ORN357PSCarbren Capital LLC · Weatherford, OKN357VSavoy Harolde M Trustee · Dallas, TXN35851Northwest Passage LLC · Anchorage, AKN35877Turbine Conversions Ltd · Nunica, MIN358CDOptimal Aircraft Management Mi LLC · Sanford, MIN358CMEathcirc 08 LLC · Tucson, AZN358DMTampa Maule LLC · Tampa, FLN358FAFoxtrot Alpha LLC · Hampshire, ILN358SANelson Robert M Jr · Plano, TXN358TPCirrus Design Corp · Duluth, MNN358YJuliet Air LLC · Cincinnati, OHN35909Flight1 Hsw LLC · Norwood, CON35932Tmzk Holdings LLC-1 · North Fort Myers, FLN35947Continental Construction Inc · Alpine, WYN35952Johnson Deborah K · Fairbanks, AKN35957Cortez Flying Service Inc · Cortez, CON359CDKomet Israel · Midland, MIN359CMCm Flyers LLC · Wayland, IA
Back to AD 2012-10-13