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.
N21554Brosten Carl V · Monclova, OHN21557Rvi LLC · Boise, IDN2155QFellows Walter · Prineville, ORN2155ROne Zero Four LLC · Germantown, TNN2155YAnderson Thomas K · Miami, OKN21562Blevins Michael W · Sayre, OKN21564Miller John H · Newnan, GAFirst renewal noticeN21566Brenner Gerald Benjamin · Oxford, MDN2156GBenson John Wesley Jr · Tecumseh, MIN2156QBowers Jackie M · Elmer, NJN2156RWinfrey Walter A Trustee · Auburn, CAN21571Schwartz Robert J · Coshocton, OHN21576Barnes Robert R · Wilton Manors, FLN2157GAviation Bravo Corporation LLC · Palm Coast, FLFirst renewal noticeN2157SSchlenker Wesley E · Dallas, TXN2157ZHamel Ryan Alan · Klamath Falls, ORN21580Bas Part Sales LLC · Greeley, CON21581Skyline Aviation Inc · Racine, WIFirst renewal noticeN21585Ck Leasing Services LLC · Wilmington, DEN21587B & D Fuel Injection Service Inc · Rhoadesville, VAN21588Jackson Hole Airport Board · Jackson, WYN2158JMccormick Eugene C DBA · Tyler, ALN2158YN2158y LLC · Pottsboro, TXN21593Peyt Rentals LLC · Cobb, GAN21597Gsw Flyers LLC · Pittstown, NJN21598Kcsi Aerial Patrol Inc · Bakersfield, CAN2159GKirchoff Kevin B · Millington, TNN2159YSmith Joshua · Watertown, MNN215AFArmed Forces Aero Club · San Diego, CAN215BABering Air Inc · Nome, AKN215BTScreen Star Inc Trustee · Wilmington, DEN215CBKw Bradley Associates LLC · Manlius, NYN215DBHurst Jeffrey A Trustee · Tahoe City, CAN215FRJjg Aviation LLC · Miami, FLN215GNBbt Jewelry LLC · Miami, FLN215JInnovative Aerodynamic Technologies · Yorktown, VAN215MCTatonduk Outfitters Ltd DBA · Fairbanks, AKN215MPPersson Timothy J · Kansas City, KSN215RGGonzalez Rogiero A · San Antonio, TXN215TXTexas Dept Of Public Safety · Austin, TXN2160JSnider Scott DBA · Turner, MTN2160RPaper Plane LLC · Hotchkiss, CON2160SGalkin Edwin N Dmd · Edison, NJN2160YOcala Aviation Services Inc · Ocala, FLN21616Joseph Tamar Bar · Chanute, KSN21618Schwend Brian · Forsyth, MTN2161EBryn Terry P · Dazey, NDN2161QSalty Dawg Aircraft Inc · Gasport, NYN2161RKlemme Aviation LLC · Davenport, IAN21626Low Level Aero LLC · Myakka City, FL
Back to AD 97-01-13