AD 2012-10-09
Registered aircraft · 150
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-09')
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-09')
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-09') 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-09') 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.
N68BJCrownair LLC · Mansfield, PAN708SAOlivier Seth Nicholas · Baskin, LAN70GWAncient City Capital LLC · Saint Augustine, FLN70TWGunter Lennon DBA · Tabernacle, NJN711ERCommunications Laboratories Inc · Melbourne, FLN723JPTiffin Aire Inc · Tiffin, OHN72JJCatton Consulting LLC · Fairfax Station, VAN730PTTwin Otter International Ltd · Las Vegas, NVN73BGRw Air Services Inc · Hatfield, PAN770MGPlan Bee LLC · Washington, DCN77NLNew South Inc · Charleston, SCN781CKSnowy Owl Aviation LLC · Charlottesville, VAN7FLCentral Virginia Aviation Inc · Petersburg, VAN7VRAja Aviation LLC · Hutchinson, MNN801HLKp Equipment Investments LLC · Cottonwood, AZN80MALsc Construction Inc · Perris, CAN818SFSierra Foxtrot LLC · Dodge City, KSN819SWWho Dey LLC · Savannah, GAN81MSCapital Craft LLC · Wilmington, DEN824CBHelfrick Edward W Jr · Elysburg, PAN827LPSagamore Aviation LLC · Lewes, DEN83CACheyenne 2 LLC · Colonial Heights, VAN83MGWatkins Jon Trustee · Florence, ORN843DBDoan Creek LLC · Walla Walla, WAN89JASouthern Aircraft Consultancy Inc Trustee · Casper, WYN901TKAviation Trust Company LLC Trustee · Oklahoma City, OKN90FSAircraft Guaranty Corp Trustee · Oklahoma City, OKN90VMJ & B Leasing Inc · Springfield, MON910AGCreative Marketing Associates Inc · Saint Petersburg, FLN910HGTiffin Aire Inc · Tiffin, OHN910JPRegistered aircraftN913NCDeweese Michel J · Rockvale, TNN914ASRed Speakers LLC · Newark, DEN917TPAerial LLC · Kalispell, MTN918FMAircraft Guaranty Corp Trustee · Oklahoma City, OKN9266YTiffin Aire Inc · Tiffin, OHN937TTPlanemarketing LLC · Vero Beach, FLFirst renewal noticeN93SHBasin Air LLC · Mattawa, WAFirst renewal noticeN944GMSix States Rentals Inc · Union, MON950CTJack Of Queens LLC · Afton, OKN96MAGoldielochs Air LLC · Annapolis, MDN970PSKrech Greg Trustee · Huron, SDN977GUS Nameplate Co · Mount Vernon, IAN980CATlh Enterprises Inc · Corsicana, TXN982KAircraft Guaranty Corp Trustee · Oklahoma City, OKN98FAHigher Purpose Aviaiton LLC · Spring Lake, MIN98TGBell Scott W · Greeley, CON990LRDavis Aviation Inc · Brandon, MSN998LMArmstrong Airlines Inc · Dover, DEN99VATwin Otter International Ltd · Las Vegas, NV
Back to AD 2012-10-09