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.
N2162GOdiorne Bruce Lamar II · Durango, CON2162ZBaker Benjamin K · Anchorage, AKN2163RRupp Michael David · Lunenburg, MAN2163ZHennis Jesse J · Nampa, IDN21641Bunger William D · Upland, NEN21643A&E Flying Club Of Los Angeles · Hawthorne, CAN21648Fox Victor Aviation LLC · Newnan, GAN21651Syverson Ronn · Mcintosh, MNN2165EMaravel Richard N · Trinity, FLN2165GStanley Aviation LLC · Stanley, NDN2165RSproket Industries Inc · Fulton, CAN2165ZRegistered aircraftN2166QLiberty Partners Inc · Okmulgee, OKN2166RKrom Raymond L · Brighton, MIN2166ZCherry William Wallace Jr · Muldoon, TXN2167CStarkys Equipment Leasing LLC · Manchester, MIN2167ESittler Charles A · Tulsa, OKN2167GBtp Inc · Missoula, MTN2167QAnderson Kevin W · Whitman, NEN2167RTake It Easy LLC · Durango, CON2167YKyriacou Nick · Detroit, MIN21686Sapp Creek Aviation LLC · Omega, GAN2168RNd Aero Solutions LLC · Bismarck, NDN2168XOrtiz Stewart Flynn · San Diego, CAN2168YBarnes Charles R · Jacksonville, FLN21690Flight Center International LLC · Hollywood, FLN21699Ramirez Sam Ernest · Yelm, WAN2169CAddison Jeffery A · Lafayette, LAN2169QWhite Beth A · Keene, NHN2169YRudy Jonathan E · New Cumberland, PAN216AFArmed Forces Aero Club Inc · San Diego, CAN216BANordic Flyers II LLC · Plymouth, MNN216CLMisamore Steven Edward · Mount Juliet, TNN216DVBusch-Joss Elizabeth M · Blue Point, NYN216JARuble Howard L Jr · Spartanburg, SCN216LBBail Air LLC · Port Saint Lucie, FLN216LHHackbarth Lee A · Bend, ORN216RFRandigo LLC · Wilmington, DEN216RGChannel Islands Aviation Inc · Camarillo, CAN216TSS&S Aircraft Inc · Bennington, VTN21709N 2 Alaska LLC · Talkeetna, AKN2170CMendez Gary · San Pedro, CAN2170EChamberlain Flying Club Inc · Chamberlain, SDN2170GPrince Ben · Lincoln, MTN2170MTucknott Robert A · Livermore, CAN2170PGmr Leasing LLC · Lincoln, DEN2170QSkowronski Steven · Demotte, INN2170SAboveallphoto.Com Inc · Indianapolis, INN21711Williams Roger P III Trustee · Mount Shasta, CAN2171FRegistration Pending · Eagle River, AKRegistration pending
Back to AD 97-01-13