AD 75-09-13
Registered aircraft · 4,787
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:75-09-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:75-09-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:75-09-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:75-09-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.
N58TTBank Of Utah Trustee · Salt Lake City, UTN58VBBeckman Donald A · Rostraver Township, PAN59007Hang On LLC · Montrose, CON59008Davis Burton D · Jefferson, IAN59011Nelson Albert N III · Baytown, TXN59041Edwards Aviation & Consulting LLC · Broken Arrow, OKN59045Air-Zancada Inc · Wilmington, DEN59049Scarry David Charles · San Luis Obispo, CAN590FMTrrek Enterprises LLC · Sunriver, ORN5910MCross Country Well Service LLC · Farmington, NMN5916MQuest Aviation Inc · Lake City, FLN59173Vogelgesang Randy · Gardnerville, NVN59258Energy Roofing Technology Se LLC · Lake City, FLN59286Staley Ronald L · Lebanon, ORN59294Cornucopia Investment Group LLC · South Jordan, UTN592GCFogelson Robert A · Tillamook, ORN5931MSteven F Danz LLC · Encino, CAN5938MKarlen John R · Boring, ORN594BVJmak Corp · Seymour, TNN594DSJsb Aviation LLC · Harrison, ARN595LTN595lt LLC · Edwards, CON595XXHolladay Logan · Salt Lake City, UTFirst renewal noticeN5962MKitov Resources Corp · Shorewood, WIN5967MN5967m LLC · Chantilly, VAN5975JFreeland Christopher G · Brownwood, TXN5988MSaltzer Eric · Somerton, AZN598ASAssociated Auction & Liquidation Co · Clarksburg, TNN598DMAirswiss Inc · Wilmington, DEN5996MMedcare Emergency Medical Services Inc · Mcallen, TXN59ABates Roger · Palm Beach Gardens, FLN59EMFletcher Marvin L · Fargo, NDN59KJSpike LLC · Cheyenne, WYN5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeN5BPTippettsolutions LLC · Fort Mill, SCN5CGSamair LLC · Blackshear, GAN5CHHartshorn William T · Tucson, AZN5CNLewis Gentry Holdings LLC · Orlando, FLN5ERMill Direct Textiles LLC · Rollinsford, NHN5HSRose Raymond P · San Diego, CAN5JKLizard Two LLC · Wilmington, DEN5NMNelson Jeffrey S · Darby, MTN5NNRkgrier LLC · Beckley, WVN5PAFinal Design Group LLC · Hurricane, UTN5ZTAllen Airplane LLC · Durango, CON60018Moreno & Nelson Construction Corp · Walla Walla, WAN6006NFraser Shane · San Marcos, TXN600DCHerron Aviation Group LLC · Dexter, MIN600HCCessna 414a LLC · Portland, ORN600PAHeaven'S Landing Realty Inc · Clayton, GAN600THN600th LLC · Fredericksburg, VA
Back to AD 75-09-13