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.
N172AAStuart S Macpherson Dds Inc · Cardiff By The Sea, CAN172ADRust Michael David · Rush City, MNN172AKGazarek Edward · Fort Myers, FLN172AMYang Chi · Lafayette, CON172APBmac Aviation LLC · Dallas, TXN172ARStraub Cordaro · Monterey, CAN172ATFulco Flyers Club Inc · Cobleskill, NYN172BTorres Marie Ivette · Corpus Christi, TXN172BACarrolls Auto And Aircraft Sales LLC · Muncie, INN172BBGlabe David Kristopher · La Grande, ORN172BCSlayton Jeffrey W · Prospect, TNN172BDMurawski Rene · Clarkston, MIN172BEAero Northwest LLC · Port Angeles, WAN172BHWright Charles L · Kirkland, WAN172BKUsaeroflight LLC · Greenville, SCN172BLMullinax Donald D · Graham, WAN172BMBarrett Jacob D · Paris, ILN172BNRedtail Aviation LLC · Rexburg, IDN172BROc Flight Lessons LLC · Costa Mesa, CAN172BSNothing Wasted LLC · Bunker Hill, INN172BTBroderick Edward P · Halifax, MAN172BXBas Part Sales LLC · Greeley, CON172CACalifornia Airways LLC · Hayward, CAN172CBRed Rock Aircraft Leasing LLC · Hurricane, UTN172CCWings Over Texas Holdings LLC · Denton, TXN172CDHnh Enterprises Inc · Lander, WYN172CESan Diego Community College District · San Diego, CAN172CFMontagne Denise A Trustee · Reno, NVN172CGWings Over Texas Holdings LLC · Denton, TXN172CHCrosby Flying Services LLC · Fort Worth, TXN172CJAlsworth Caleb J · Port Alsworth, AKN172CLByrne Matthew A · West Allis, WIN172CPShevchenko Antonina · Henderson, NVFirst renewal noticeN172CWGoddard William W · Apple Valley, CAN172CXBias Aviation LLC · Crossville, TNN172DADuncan Aviation · Lincoln, NEN172DBK&T Aviation LLC · Milton, PAN172DDMurphy Dylan James · Murphys, CAFirst renewal noticeN172DFMajercik Donald A · Jericho, VTN172DGGrass Daniel L Trustee · Penn Valley, CAN172DKVertikle Enterprises LLC · Cheyenne, WYN172DLKling Aviation Inc · Friendswood, TXN172DMErquiaga Jeff H · Rushville, NEN172DPSuperior Aviation Gateway LLC · Tampa, FLN172DSJb Air Services LLC · Framingham, MAN172DTMilam Six LLC · Milam, TXN172DVLima Tango Aviation LLC · Mount Dora, FLN172EPlymouth Flying Club Inc · Plymouth, NHN172EBMiller David A · Kodiak, AKN172ECNilo Aviation LLC · Arley, AL
Back to AD 97-01-13