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.
N375RHyannis Air Service Inc DBA · Hyannis, MAN375RBMarinella Leasing LLC · Chandler, AZN375RRRegistered aircraftN375SBPrecision Aerobatics Inc DBA · Santa Margarita, CAN375THRbm Records And Promotion LLC · Clinton, OHN375TT4two9 Aviation LLC · Princeton, FLN3761PSky Rollers LLC · Merritt Island, FLN376BCKunz Paul C · Midway, UTN376CDWestern Chancellor LLC · Fort Worth, TXN376PDStriplin Donald B · Mammoth Lakes, CAN376RHSeckel Dean · Mount Vernon, WAN3777SStuart Guy · Owosso, MIN377ALKairis Perry A · High Point, NCN377AMJohnstone Inc · Wilsonville, ORN377BCMelcor Aviation LLC · Hopkinton, MAN377CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN377CFCohen Rolando S · New York, NYN377DZCsc Capital Holdings LLC · Nashville, TNN377JJThree L Aviation LLC · Victor, NYN377JS270 Aviation LLC · Elizabethtown, KYN377MRMaquinarias Repuestos Inc · Miami, FLN377PCBenson Fred B · Cle Elum, WAN377RGGruett Gregory C · Lititz, PAN377SRAero Pacific LLC · Kentfield, CAN377TXFauber Dan · Granbury, TXN377X3 Jrks Flying LLC · Jackson, MIN378CTamavo Inc · Baltic, SDN378FJSouthern Aircraft Consultancy Inc Trustee · Casper, WYN378GLReel Trip LLC · Knightdale, NCN378JHPtj Associates LLC · La Canada Flt, CAN378PHRegistered aircraftN378SStarr William E · Eagle River, AKN378TAFull Time Betty LLC · Friday Harbor, WAN378WTFeeser Flight Services LLC · Odessa, TXN3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIN3796GSantos Aviation LLC · Chico, CAN3799PCt Services LLC · Albuquerque, NMN379CDOptimal Aircraft Management Mi LLC · Sanford, MIN379SRSweetwater General Contracting LLC · Cumming, GAN379TWTanglewood Aviation LLC · Fort Mill, SCN37BAAmbler Robert L · San Diego, CAN37CLAlexander Wolf Corp · Reno, NVN37EWKundel Andrew R · Muscatine, IAN37GMCraft Engineering Associates Inc · Hampton, VAN37GTBig Bang Air LLC · Wichita, KSN37KHKlmk LLC · Beaumont, TXN37LGBrody Michael J · Truckee, CAN37LTValiair Lc Trustee · Casper, WYN37MGWood Ronald G · Weatherford, TXN37PB37pb Inc · Seattle, WA
Back to AD 2012-10-13