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.
N97JKAviation Trust Company LLC Trustee · Oklahoma City, OKN97JYLancair 1074 Inc · Lewes, DEN97LTWallace James R Jr · Oneonta, ALN97LXWhy Knot Fly LLC · Naples, FLN97MKEquity Estates LLC · Lexington, KYN97PPMlk Holdings LLC · Newark, DEN97PWKelley Larry A Jr · Port Arthur, TXN97RJN97rj Airplane LLC · Leesburg, VAN97STRegistration Pending · Hubertus, WIRegistration pendingN97VCSababa Aviation LLC · West Palm Beach, FLN97VKMore Less 7vk LLC · Lewes, DEN97VTDelta Mike LLC · Blacksburg, VAFirst renewal noticeN980AMC&P Aircraft Holdings LLC · Nacogdoches, TXN980MLBluegreene Skies LLC · Brentwood, TNN980RJCirrus 0980 Aviation Inc Trustee · Wilmington, DEN980SCSky Horse LLC · Santa Cruz, CAN981AKState Of Alaska · Anchorage, AKN981ARCloud Nine Adventures LLC · Jupiter, FLN981BKBmk-Sy LLC · Clarkston, MIN981CDThumb Aero LLC · Sandusky, MIN981DMMartin David E · Dallas, TXN981JN 981 J LLC · San Antonio, TXN981JWWill Tucker Aviation LLC · Wilmington, DEN981KCumberland Aviation LLC · Corbin, KYN981PSunderman Randy D · Norfolk, NEN981PGJam Cellars Investments LLC · Napa, CAN981WBFlying Fortress Of Swfl LLC · Fort Myers, FLN982CDLeon Arnaldo · Las Vegas, NVN982JMMiller Aviation LLC · Fort Mill, SCN982PWValley Wide Cooperative Inc · Nampa, IDN9836PTurbo Property LLC · Clovis, CAN9836SForest Kevin · Langdon, NDN983CDN983cd LLC · Chattanooga, TNN983DBBunke Jim Bradley · Denver, CON983JBConstellation Aviation LLC · Rock Springs, WYN983WPHallows Hc Holdings LLC · Salina, UTN9843YCavu Solutions LLC · Renton, WAN9848MCovington Aircraft Engines Inc · Okmulgee, OKN984JPPerry Christopher J · Chicago, ILN984KCT4 Equipment LLC · Boone, NCN984VBHorton Aviation LLC · Greensboro, NCN984WMFly Mah LLC · Durham, NCN98533Bla Holdings LLC · Mcminnville, TNN9853COregonian Flying Club · Wilmington, DEN98554Hawke Air Corp · Helena, MTN98579Bailey Switch Rentals LLC · Bluefield, VAN98590Tuc-Mex LLC · Nogales, AZN985BWCr Aviation LLC · Budd Lake, NJN985EKQualitair LLC Trustee · MichelsladtN98613Aero Innovations LLC · Tempe, AZ
Back to AD 2012-10-13