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.
N279TXHester Air LLC · Visalia, CAN27BGGuzman Steven Manuel · Port Saint Lucie, FLN27DJLiberty Air LLC · Sarasota, FLN27EBWalker Co · Cody, WYN27EMStair Colin · Brookfield, WIN27GPFlying Colors Airparts Inc · Leesburg, FLN27GRGolf Romeo Aviation LLC · Raleigh, NCN27HALmn Aircraft Leasing LLC · Sellersburg, INN27LEQuality Feed Grains · Harrison, ARN27LGStilda One LLC · Fort Loramie, OHN27MLHam Aviation LLC · Marydel, DEN27MXStewart Aviation LLC · Atlanta, GAN27MYBloomaker Holding Aero Service Inc · Waynesboro, VAN27PBMountain Lake Aviation LLC · Newark, DEN27PFNorthstar Global Flight LLC · Bronxville, NYN27PKOgary Aviation LLC · North Little Rock, ARN27PY27py LLC · San Juan, PRN27RGReya Sunshine LLC · Coral Gables, FLN27SC5c Aviation LLC · Scottsdale, AZN27TSSalerni Anthony A · Bedford, NHN27VPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN27WVN27wv LLC · Shortsville, NYN2801LAv8sgf LLC · Rogersville, MON2802JCentral States Aerial LLC · Polo, ILN2803MBonanza N2803m LLC · Conway, ARN280CDWelling Lynn E · El Cajon, CAN280CPAi Aviators LLC · Vancouver, WAN280LVagiunic David · Ridgewood, NYN280LCEstes Aviation LLC · Carson City, NVN280SREdge Forward LLC · Thermopolis, WYN2814QGill Robert L · Dixon, CAN281BKCz Enterprise LLC · Loveland, OHN281CPJust Plane Insane LLC · Missouri City, TXN281DSBoughton Kyle · Mckinleyville, CAN281MFFisher Robert · Durham, NCN281MGCirrus Design Corp · Duluth, MNN281SRLawyers Real Estate Services LLC · Hondo, NMN281SVOlson Fred · Harrison, ARN281UDStanley David Wayne · Burleson, TXN281VBarry Larry M · Woodbine, IAN282Sh1p Holdings LLC · Wichita, KSN2824MDodson International Parts Inc · Rantoul, KSN2824WBrown Logistics LLC · Auburn, WAN282ATMoonraker Iixl LLC · Wilmington, DEN282CBWhisky Tango LLC · Hendersonville, TNN282CDAurora Partners LLC · Oregon City, ORN282DJViva LLC · Dover, DEN282DMSkyshoe II LLC · Beverly, MAN282EEFogprop N282ee LLC · Bolinas, CAN282THAero Sky Inc · Terrace Park, OH
Back to AD 2012-10-13