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.
N66PCHeinzle Hamblin LLC · Eagar, AZN66PE811wm LLC · Watertown, CTN66RAGasu LLC · Henderson, NVN66SBBay West Aviation LLC · San Francisco, CAN66SFRed Rock Flying School LLC · Mesa, AZN66TEFly4fun LLC · El Segundo, CAN66TMBarronena LLC · San Antonio, TXN66VGVg Management LLC · Orinda, CAN66VMPg Air LLC · Bellbrook, OHN66WSDighans Murray · Peerless, MTN6700PAbraham Curtis · Byron, WYN6709QClear Blue Marketing Inc · Reno, NVN670CAValiair Lc Trustee · Casper, WYN670CMRedx LLC · North Palm Beach, FLN670DSSongbird Leasing LLC · Nashville, TNN670PCw Veach Logistics LLC · Allerton, IAN670PNAir Powers LLC · Warrensburg, MON6715RRose Mary R · Portland, ORN671BBe-A36 Inc Owner Trustee · Wilmington, DEN671JBAerostone Holdings LLC · San Saba, TXN671JLJgl Aviation LLC · Boca Raton, FLN671MVJtmtrl LLC · East Haven, CTN671PAMorray Fl LLC · Port Charlotte, FLN671SMRegistered aircraftN671TSpartin Investments LLC · Gallup, NMN671TCBraunstein Robert S · Seattle, WAN67224Vx Inc · Burbank, CAN6722BJca Aviation LLC · Safford, AZN6726SSchaney Michael W · Brookville, OHN6728FPeters Bruce L · Wichita, KSN6728RRegency Horizons Group LLC · Middletown, DEN6728ZMccrorie LLC · Helena, MTN672CDRegistered aircraftN672HBValiair Ltd Co Trustee · Casper, WYN6731ZJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeN6733MWilson Lawrence J · West Sacramento, CAN6734UR E Bentz Inc · Monroe, LAN6736TBrakke Thomas · Clear Lake, IAN6737VRiverview Ranches · Chowchilla, CAN6739CPearce William · Grants Pass, ORN673CDR58 Aviate LLC · Granbury, TXN673DKBh Aero LLC · Hanover, MNN673RVMev Aviation LLC · Fort Lauderdale, FLN673SRHarrison Terry W · Soldotna, AKN673TBalchunas Anthony B · Robinson, TXN67414Staley Clifford D · Delray Beach, FLN6741MCooper Aviation LLC · Georgetown, SCN6745YSeamech International Inc · Houston, TXN6746RSchwartz Daniel T · Meeker, CON6748CSan Andres Farms · Raymondville, TX
Back to AD 2012-10-13