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.
N23197Martin Michael E · Doniphan, MON2319FDelaney Patrick J · Marion, TXN2319GSkydive Co · Fairburn, GAN2319UGriffin Edward L · Bowling Green, KYN231JPQuest Air Inc · Cocoa, FLN231PTLobbytools Aviation LLC · Friday Harbor, WAN231SCBice Crystal Harmon · Temple, GAN23205Registration Pending · Orchard, IARegistration pendingN23206Schwind Bernard J · Kaunakakai, HIN2320ESky Farmer LLC · Culleoka, TNN2320GStocker Earnest E · Krum, TXN23218Registration Pending · Utica, KYRegistration pendingN2321FMilson Charles · Sanford, NCN23221Bartosh David W · Abbott, TXN23228Johnston David W · Vero Beach, FLN2322CTwin Otter Internatinal Ltd · Las Vegas, NVN2322GBaker Harry K · Phoenix, AZN2322RSink Lendon V · Lexington, NCN23231Jones Robert A · Smyrna, DEN23232Ozment Dennis W · Palmyra, MON23237Berrong Jimmy L · Dahlonega, GAN23238Plane Simple Rentals LLC · Monroe, MIN2323COrvin Sanden Inc · Wyndmere, NDN2323FMattern Rodney · Napoleon, NDN2323GLeone Daniel M · Pueblo, CON2323UBurch Daniel C · Oakdale, MNN23246Pripps Seth D · Appleton, WIN23248Kainu William M · Santa Rosa, CAN2324FLong Rendell L · Woodbridge, VAN2324RKincheloe Ralph H · Jerome, IDN2324XSchutjet Dennis · Clear Lake, IAN23251Smith Lyndsey P Trustee · Anchorage, AKN2325FStephen N Ruark Farm Services Inc · Pantego, NCN2325RLucky Catch LLC · Canton, MSN23261Asher Howard J · Kansas, OKN2326BRandigo LLC · Wilmington, DEN2326RSinger Don · Oxnard, CAN2326XFerris Elden L · Vancouver, WAN23270Simco Aviation LLC · Petal, MSN23271Monnig Hans J · Westerville, OHN23273Herrema Kendra L · White Cloud, MIN23274Brogmus Rhyan P · Marana, AZN23275West David J · Plymouth, CAN23276Spellacy Cynthia L · Seaside, CAN23277Kressin Rayh · Waunakee, WIN2327FWilliams Stephen Mark · Fort Walton Beach, FLN2327USprague Jeremiah A · Halfway, ORN23281Sosa Jonathan · Orlando, FLN23284Providence Industrial Electronics Repair Inc · Pilot Mountain, NCN23287Bocanegra Jorge S · Greenville, NC
Back to AD 97-01-13