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.
N414AWAlycone Trust Corp Trustee · Wichita, KSN414BDBostater Charles Jr · Indn Hbr Bch, FLN414BGGreen Forest Aviation LLC · Edmond, OKN414BH414bh LLC · Laramie, WYN414BLBig South Fork Aero Inc · Huntsville, TNN414BMBorden John · Raleigh, NCN414BSHunger Relief Ministries · Forney, TXN414BTCmo Blue Sky LLC · Tomball, TXN414BWSky West Aviation Inc Trustee · Albuquerque, NMN414CASurgeon LLC · Arcadia, LAN414CDRepinter (Delaware) Inc · Coral Gables, FLN414CELocaero Services Inc Trustee · Wilmington, DEN414CKN414ck LLC · Tacoma, WAN414CLL Squared Aviation LLC · Marine, ILN414CMMartin Livestock LLC · Ione, CAN414CNAllied Asset Management LLC · Oklahoma City, OKN414CPCsu Aviation LLC · Plainfield, INN414CRAga Aviation LLC · Woodruff, SCN414CTHollywood Aviation Investments LLC · Hollywood, SCN414CWCrosswind Media LLC · Terrell, TXN414DBNerwelah Holdings LLC · Martinez, GAN414DDModern Custom Design LLC · Melbourne Beach, FLN414DKOn Top Aviation LLC · North Las Vegas, NVN414DLRestivo Joseph Sal · Cape Coral, FLFirst renewal noticeN414DNN5454x LLC · Lafayette, LAN414DPPlane Crazy Aviation LLC · Hollywood, SCN414DSGable S Corp · West Linn, ORN414DVSnoopy'S Aviation LLC · Porterville, CAN414DWAgrigro Midwest Aviation LLC · Poplar Bluff, MON414EESp Aviation Inc · Hayward, CAN414EGHardrock Transport LLC · Pulaski, VAN414EHSurdex Corp · Chesterfield, MON414ELKillion James L · Lubbock, TXN414ESPork Chop Express Aviation LLC · Las Cruces, NMN414EZMrjl LLC · Wilmington, DEN414FAGardiner Scott · Apache Junction, AZN414FBMk414 LLC · Fredericksburg, TXN414FCTaff Logistics LLC · Gilmer, TXN414FGGrisham Charlie · Odessa, TXN414FTR Yokem Aviation LLC · Shreveport, LAN414GGenerations Flying Club LLC · Washington, MON414GBHeritage Rotors LLC · De Leon Springs, FLN414GGHangar 21 Aviation LLC · Shreveport, LAN414GKJoho Aero LLC · Georgetown, TXN414GPSs Aviation LLC · Sulphur, LAN414GRHuron Mountain LLC · Grand Rapids, MIFirst renewal noticeN414GSDelaney Lee Aviation LLC · Grand Rapids, MIN414HBRaj Leasing Mt LLC · Missoula, MTN414HCBrothers Aviation LLC · Black Rock, ARN414HFN414hf LLC · Jasper, GA
Back to AD 2012-10-13