AD 97-01-13
Registered aircraft · 54,837
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:97-01-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:97-01-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:97-01-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:97-01-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.
N3184RGardner Daniel J · Alvord, TXN3184SThrash Farms Inc · Pelahatchie, MSN3184XSandlapper Aviation Of De · Bennington, VTN3184YFunkhouser David E · Weatherford, OKN3185DMorgan Douglas C · Anchorage, AKN3185F85 Foxtrot LLC · Redmond, ORN3185QPara Tactics LLC · Shelton, WAN3185XSanders John L · Sikeston, MON3185YGochenour Air Inc · Fort Wayne, INN3186DSutton Aircraft Salvage LLC · Palmer, AKN3186JHowenstein John G · Roseville, CAN3186QKimbril Steve · Hartselle, ALN3186RHuey Gale R · Celeste, TXN3186XPanus Mark V · Hinsdale, NYN3186YJram Air Parts LLC · Henderson, NVN3187CHemm Colby L · Newcastle, CAN3187FVolatile Aero Ventures LLC · Boulder City, NVN3187JBrar Amuldeep S · Austin, TXN3187UMillikan Kimball S · Honolulu, HIN3187YMiller Richard G · Anson, TXN3188JFlight Time Builders Inc · Memphis, TNN3188QLutz Paul A Trustee · Seville, OHN3188SCrossman Charles · Rusk, TXN3188TRucinski Edward A · Climax, NCN3188UAsb Avionics LLC · Mojave, CAN3188YIngram Patrick Joseph · Pinedale, WYN3189CSmith David J · Duluth, MNN3189SMarvin Franz Interests Inc · Victoria, TXN3189ULaney Donald R · Inkster, MIN3189VMunn Julian · Spring, TXN318CCVan Schoonhoven Nicholas R · Kent, WAN318DMDelta Kilo Mike LLC · Rayville, LAN318NRNorthern Arizona Investment Group LLC · Prescott, AZN318PPK&A Consulting Of Montana Inc · Billings, MTN318PWN318pw LLC · New Canaan, CTN318RAllen Timothy J · East Kingston, NHN318RCLafrance Lon H · Rocky Mount, MON318SCMooney Frank X · Friendswood, TXN318TWFlg Air Transport LLC · Miramar, FLN318UTraffic Law LLC · Tampa, FLN318VFShramek Troy A · Bossier City, LAN3190DDooyema Eric · Spokane, WAN3190FTimbol Julius J · Fair Oaks, CAN3190JSimon Mitchell B · Edison, NJN3190QHilton John C · Glastonbury, CTN3190RPace Richard · Leighton, ALN3190UTo Brand · Stanton, TXN3190XOso Air LLC · Missoula, MTN3190YSpencer Thomas D · Brentwood, TNN3191CVaneau Phillip M · Wasilla, AK
Back to AD 97-01-13