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.
N222PXRegistered aircraftN222QLindeen Karen D · Anchorage, AKN222QAKlopotek Jerome P · Orangevale, CAN222RDAviation Consultants Inc · San Luis Obispo, CAN222RMKelco LLC · Helena, MTN222SADenny Robert C · Fort Myers, FLN222SBFuglestad Jon T · Anchorage, AKN222SJTriple Deuce LLC · Harrisonville, MON222SVEllsworth Jason W · Hamilton, MTN222TADeschene Michael R · Westminster, CAN222TKMachowicz Mark M · Eastpointe, MIN222TXJ M Williams LLC · Stockton, CAN222USTicoair LLC · Wilmington, DEN222WAWiseman Aviation Inc · Flagstaff, AZN222WFBailey Steve · Chehalis, WAN222WKSchellhorn Friedrick · Harxheim/MainzN222XLFox Jeffery R · Spooner, WIN22304Berry Dewey R · Lexington, SCN22305Arend James E · Mesa, AZN22307Martin David O · West Mifflin, PAN2230898x LLC · Caddo Mills, TXN2230CHendricks Construction LLC · Phoenix, AZN2230DHendricks Construction LLC · Phoenix, AZN2230JCragg Gordon E · Georgetown, TXN2230WJac & Phill Corp · San Ysidro, CAN22310Tackett Eric · Huntington, INN22318Reggie Denis A Jr · Marietta, GAN2231GKelly Richard · Ogdensburg, NYN2231THewitt David E · Newcastle, MEN22325Marlee B Thomas · Tolar, TXN22329Guernsey G R · Belen, NMN2232EPink Skies Inc · Willoughby, OHN2232GBigler Mark · Topeka, KSN22335Johnson Marissa N · Avon, INN2233GA F Flyers LLC · American Falls, IDN2233JPalmer Kim W · Lockport, NYN2233RDorman William James Trustee · Anchorage, AKN2233SRichardson Robert O · Spring Grove, ILN2233TSeward Air Taxi LLC · Seward, AKN2234GBaldwin Trevor K · Owasso, OKN22351Air Discovery La LLC · North Hollywood, CAN22354Franks Cory · Idalou, TXN22355Quinones Steven · Forney, TXN2235ELivingston Eric L DBA · Winchester, INN2235JKnutson Wayne R · Thompson, NDN2235QSparx Logistics USA Ltd · Charlotte, NCN22360Levy Peter F · Augusta, KSN22361Youngblood Steve R · Young Harris, GAN2236QWoods Leland W · Klamath Falls, ORN2236TParks Walter G · Chugiak, AK
Back to AD 97-01-13