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.
N44TAlpha Aviation 1 Inc Trustee · Wilmington, DEN44TTArrow Aviation LLC · Wayne, PAN44WFWildy David · Manila, ARN44WHKelly Sean R · Bozeman, MTN44WWHauser Michael L · Glendale, AZN44WXA O Retail Consulting Inc · Oconomowoc, WIN44XJRegistered aircraftN4500KEaston Gregory D · Montrose, CON4509JHill Curtis E · Bancroft, IDN450CDAlcyone Trust Corp Trustee · Wichita, KSN450CSCbcb Aircraft LLC · Colfax, WAN450SUMore Right Rudder LLC · Edmond, OKN450TXM And M Aviation Leasing LLC · Wilmington, DEN4519SBlanck Greg J · Redwood City, CAN451CADelaware Aircraft Trust LLC Trustee · New Castle, DEN451JSPoole James Gregory III · Raleigh, NCN451LXBassen Gerald R · Saint George, UTN451MTimothy Duane High · Glenwood, MON451MVOne Mike Victor Aviation LLC · Belmont, CAN451RKHeine John C · Santa Barbara, CAN451SGNolt Air LLC · Lititz, PAN451SRSkywalk LLC · Olive Branch, MSN451TJSr22 Aviators LLC · Crete, ILN451VLSo Fly Aviation LLC · Eugene, ORN4522KGoodman Jack A · Memphis, TNN4528JRobertson Crop Dusting Service Inc · South Haven, MIN452CWashington Derrick A · Louisville, KYN452CDTimber Ridge Aviation LLC · Wilmington, DEN452JGQualitair LLC Trustee · MichelstadtN452MDHeartsill Lucas G · San Angelo, TXN452TTCharney Howard S · Genoa, NVN452TXEfficient Transportation Services LLC · Harpers Ferry, WVN452VABegio Aviation LLC · Arlington, VAN4533JStevens Investment Group LLC · Elsie, MIN4537QInstant Security Service Inc · Wilmington, DEN453MFSpain William D Jr · Mahopac, NYN453SAHts LLC · Hudsonville, MIN4547SLorentz Aviation LLC · Canadian, TXN454CPWestern Chancellor LLC · Fort Worth, TXN454RCRcr Aviation LLC · Cartersville, GAN454RKFiore Christopher · Forked River, NJN454SDDelcampo Holdings LLC · Atlanta, GAN454SPSps Investment Properties LLC · Macon, GAN454SRFaisal Tameesh · Sterling Heights, MIN4555Glass Bagging Ent Inc · Duncansville, PAN4557NWestra Aviation LLC · Beaver Dam, WIN455AH.5 Moon LLC · Cheyenne, WYN455BDArchco II LLC · Bloomfield, NEN455CDSanta Barbara Biplane Tours LLC · Santa Barbara, CAN455JRHinaa Hidaa LLC · Chino Valley, AZ
Back to AD 2012-10-13