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.
N711HQLa Joya Aviation LLC · Encinitas, CAN711KDDelta Kilo Mike LLC · Rayville, LAN711KRMi Leasing LLC · Knoxville, TNN711KWCrosswind Aviation Ltd · Wilmington, DEN711PJRender Chad · Pine Bluff, ARN711QTTax Law Offices Of David W Klasing Pc · Irvine, CAN711SDMundy William L · Proctorville, OHN711TCShimberg Aviation LLC · Tampa, FLN711TWMartens Ruth C · Wheaton, ILN711WJBeaubien Philippe R · Houston, TXN711XXJci Leasing LLC · Moultrie, GAN711YLBurkett Gary L Trustee · Murfreesboro, TNN712ANAkn Air LLC · Middleton, WIN712ATWegner Cole Aviation LLC · Lincoln, NEN712BCMoss Aviation LLC · Grand Rapids, MIN712BESunset Reef Aviation Services LLC · Wilmington, DEN712CDLamadera Enterprises LLC · Lufkin, TXN712CMFrida Aviation LLC · Anaconda, MTN712GLThere And Back LLC · Tulsa, OKN712HWK&A Heel Hawk LLC · Durango, CON712LFMcplane LLC · East Lansing, MIN712LSDwyer Stephen C · The Woodlands, TXN712MBZero 24 Interests LLC · Houston, TXN712NDAircraft Guaranty Corp Trustee · Oklahoma City, OKN712RALone Mountain Aircraft LLC · Vandalia, OHN712RMCrown H Cirrus LLC · Casscoe, ARN712RXWhiskey Kilo LLC · Monroe, LAN712SBSinger Nathan · Pismo Beach, CAN712SCKilo-Seven Aviation LLC · Annapolis, MDN712WPWhiskey Papa Aviators LLC · San Diego, CAN7131Van Dyke Bryan C · Wichita, KSN7131GKao Allen K L · Burnsville, MNN71357Horn Associates 2 LLC · Brookline, MAN713CDCamoin Robert J II · Suffield, CTN713CTCt Corp · Porter Ranch, CAN713GGLomi Aviation LLC · Houston, TXN713GMStubbs Brian E · Knoxville, TNN713HL713 Hotel Lima LLC · Butler, PAN713JBBowers Bradley D · Anderson, SCN713KVKvo713 LLC · Tupelo, MSN713RDGrow Rich LLC · Wilmington, DEN713SBAnderson Adam Lee · Loomis, CAN713SRMike & Matts Plane LLC · Brooklyn, NYN713TGSelway Construction Group LLC · Moscow, IDN713TRTrg Texas Holding Group LLC · The Woodlands, TXN714BMMurphy Randall · Ruston, LAN714DBIpiranga Inc · Houston, TXN714FTFly Me To The Moon LLC · Chicago, ILN714VUKa Cirrus Inc Trustee · Wilmington, DEN715AHKau Lynn M · Rye, NY
Back to AD 2012-10-13