AD 2012-17-06
Registered aircraft · 2,157
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-17-06')
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-17-06')
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-17-06') 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-17-06') 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.
N5370PBlythe Anne T · Paso Robles, CAN5374PDeflorin David J · Harris, MNN5376PDuffield Michael · Sorrento, FLN5377PRegistration Pending · Litchfield Park, AZRegistration pendingN5381PRiggs Michael · Yoder, CON5382PBryant Ashley Kae · Fort Worth, TXN5386PRendezvous Air LLC · Riverton, WYN5387PStewart Aaron K · Murdock, NEN5388PHeadings Andrew R · Blue River, WIN5389PJaehn Lawrence E · El Cajon, CAN538PMueller Lawrence A · Jackson, GAN5391PWilliams Keith A · Pahrump, NVN5394PHanneman Michael W · Abilene, TXN5397PGregg George H · Vandergrift, PAN5398PB2w Corp · Winona, MNN5403PSwartwood Scott S · Colorado City, CON5404PClough Robert A · Grass Lake, MIN5405PJohnson Sidney · Madison, MNN5406PDerksen Ronald E · Xenia, ILN5408PZero Eight Papa LLC · Dublin, OHN5409PReinaudi Gael · New York, NYN5411PLarson Andrea S · Wasilla, AKN5417PMoran Patrick D · Pleasanton, CAN5419PTrease Marvin R · Elwood, NEN5423PPapp Frank J · Fort Mohave, AZN5424PHerreid William L Jr · Prairie Du Chien, WIN5426PTromble Tim L · Story, WYN5429PSky West Aviation Inc Trustee · Albuquerque, NMN5430PHeight David B · El Prado, NMN5434PDavison Matt E · Pueblo, CON5437PDeplorable Air LLC · Lakeland, FLN543JDSybesma Troy S · Claremont, MNN5440PWurlitzer Lindsay Pabst Trustee · Healdsburg, CAN5441PBellah Mark E · Alva, OKN5442PMountain Air Restoration · Bend, ORN5443PSbroglia Gregory A · Farmington Hills, MIN5446PRegistration Pending · Cypress, TXRegistration pendingN5448PStarfire Aviation LLC · Conyers, GAN5450PRegistration Pending · Sun Lakes, AZRegistration pendingN5451PWilliams Andrew B · Mineral Wells, TXN5452PLewis Nathan W · Vale, ORN5453PNoel Andrew F Jr · Morton, WAN5454PRio Grande Flying Association Inc · Center, CON5455PWheeler Douglas A · Mount Vernon, OHN5456PYates Kenneth B · New Boston, TXN5459PAirclimax Inc · Milan, TNN5460PT & C R Wing'N It LLC · Tempe, AZN5461PGraham Truett A · Lubbock, TXN5466PGriffith Charles · Santa Maria, CAN5467PMeyers Terry E · Galesburg, ND
Back to AD 2012-17-06