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.
N9612RBearnose II LLC · Edina, MNN9613GDavid W Easter Consulting Inc · Libby, MTN9614KPassmore Stephen B · Lacrosse, WAN961CDSouthpoint Development Inc · Jacksonville, FLN961MCBig Rooster Aviation LLC · Coralville, IAN961TTLupia Raul H · Raleigh, NCN9621J21 Juliet Aviation LLC · Carlsbad, CAN9624MWater Solutions Inc · Half Moon Bay, CAN962MBDouble A Aviation Group LLC · Harrison, NYN962PWHamilton Jesse L · Aledo, TXN962SRExploration Aviation LLC · San Antonio, TXN962SYLatin Aviation LLC · Aventura, FLN9632ZAngelone Inc · Elkhart, INN96335Cysewski Roxanne Trustee · Rllng Hls Est, CAN9635CAirmans Aviation Co Ltd · Fort Smith, ARN9636YCarranza Chris J · Stanfield, AZN963APJhmh Aeronautics LLC · Six Mile, SCN963ARArtyair LLC · Cranberry Township, PAN963AWTesseract Aviation LLC · Colorado Springs, CON963BBNc Aviation LLC · Missoula, MTN963CDBraden Health LLC · Greensboro, NCN963DBCommonwealth Aircraft Inc · Ashland, VAN963DMHaugen'S Hangar LLC · Williston, NDN963RBAmerican Fine Art Inc · Scottsdale, AZN963RTAppalachian Foothills Contracting Inc · Lexington, KYN9643ZAdams Aviation Services Inc Trustee · Wilmington, DEN9649GAllen Todd N · Mccall, IDN964CDSolkshinitz Andrew · San Luis Obispo, CAN964HRAnderson Ridge Holdings LLC · Lewes, DEN964SGWing Nuts Flying Club Ltd · North Chesterfield, VAN965GHHancock Aircraft Sales LLC · Baton Rouge, LAN965PWBeary Douglas Louis · Cary, NCN965PZMc 81 LLC · Wellsville, UTN965XML Merlo LLC · Rockville, MDN966MGAirtrust LLC -6- Series 6 Trustee · Sheridan, WYN966MPPerone Michael S · Fort Pierce, FLN966TTClemmer Rodney Duane · Roanoke, VAN966UBTex Ark Air Corp · Melissa, TXN9674GN1705r Inc · Cobb, CAN9675RBeechcraft Heritage Museum Inc · Tullahoma, TNN967CMoran Transport LLC · Westminster, MAN967KJHolland Willard T · Akron, OHN967RBCrafter Aviation LLC · Park City, UTN968BGValley Air LLC · Folsom, CAN968CCSun Auto Tire And Service Inc · Cape Girardeau, MON968CDSchultz James A · Folsom, CAN968PHArmstrong Aviation LLC · Nashville, TNN968RAble Aviation LLC · Bolton, CTN9691ZSouth America Mission Inc · Fort Mill, SCN9693ACavu LLC · Honolulu, HI
Back to AD 2012-10-13