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.
N59PJTad Holdings LLC · Little Falls, MNN59PXWaypoint Aviation Group LLC · Lenoir City, TNN59SBLearson LLC · Tarpon Springs, FLN59WVSanders Graham · State College, PAN59ZZN59zz LLC · Croton On Hudson, NYN5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeN5APOver The Airway LLC · Missoula, MTN5BPTippettsolutions LLC · Fort Mill, SCN5CCMoon Ape LLC · Las Vegas, NVN5CGSamair LLC · Blackshear, GAN5CNLewis Gentry Holdings LLC · Orlando, FLN5DSCirrus Flying Professionals LLC · Hollywood, FLN5DVJ4 Aviation LLC · Winter Haven, FLN5ERMill Direct Textiles LLC · Rollinsford, NHN5EVAndersen Tyler · Las Vegas, NVN5JKLizard Two LLC · Wilmington, DEN5KBCirrus Design Corp · Duluth, MNN5KMB & B Aviation LLC · Vineyard, UTN5MKTysam Aero LLC · Graford, TXN5NMNelson Jeffrey S · Darby, MTN5PAFinal Design Group LLC · Hurricane, UTN5PR3rd Season LLC · Carrollton, TXN5PVBlack Hills Aviation LLC · Saint Cloud, MNN5QETroutman Shawn L · Johnson, KSN5SSterling David M · El Cajon, CAN5SVPlane Metrics LLC · Fort Worth, TXN5TTRoosa John · Tucson, AZN5WFMociva Inc · Del Mar, CAN5XNHuddart Martin · Farmington, CTN5YVVasilik Kenneth E · St George, UTN5ZTAllen Airplane LLC · Durango, CON60018Moreno & Nelson Construction Corp · Walla Walla, WAN60034Jpb Holdings Inc · Kalispell, MTN6005CWings And Wedges LLC · Fort Lupton, CON6005LPeairs Gregory Ross · Sacramento, CAN6006NFraser Shane · San Marcos, TXN600BZCirrus Design Corp · Duluth, MNN600HCCessna 414a LLC · Portland, ORN600KG600kg LLC · Middletown, DEN600KTAtaraxia Aircraft Holdings LLC · Greenville, SCN600LBSas Cirrus Vannes Inc Trustee · Cheyenne, WYN600PAHeaven'S Landing Realty Inc · Clayton, GAN600RVAero-Tech Services Inc · Lititz, PAN600SKMorin Aviation LLC · Accident, MDN600THN600th LLC · Fredericksburg, VAN600WLMoore Stan D · Amarillo, TXN6012BQualitair LLC · MichelstadtN6012SWhaley Carl S · Shelby, NCN6013BFrost Sean D · Lovell, WYN6013UGideon Aero LLC · Dayton, OH
Back to AD 2012-10-13