AD 71-13-01 R1
Registered aircraft · 6,916
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:71-13-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1')
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:71-13-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1') 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.
N92ZSky Galaxy 1 LLC · Lake Placid, NYN9303PDyster Justin C · Coeur D Alene, IDN930BMCoastal Aviation LLC · Nags Head, NCN930CMR F Cooper Enterprises LLC · Scottsdale, AZN930CTStark Holdings LLC · Kalispell, MTN930KGGriggs Roger · Columbia, SCN930MDTab Associates Inc DBA · Port Saint Lucie, FLN930ZMirage 930 Corp Trustee · Wilmington, DEN9311PJjjfgt Capital Holdings LLC · Truckee, CAN9312PGregory John P · Riverside, CAN9313PPencosky Edward A Jr · Manorville, NYN9315PGrady Michael J · Farmington, NMN9316PProvost Stephen Nicholas · Saint Louis, MON9317PFutter John H · Whately, MAN9318PPorter Wayne · Phoenix, AZN9318WAutoscribe Arrow LLC · Fort Lauderdale, FLN931SAMarc Inc · Bolton, MSN931TTCompass Pro LLC · Baldwin, WIN931VMVermeer Great Plains Inc · Olathe, KSN9321PRegistered aircraftN9324FKrueger Michael L D O · Fresno, CAN9325PCody William James · South Lyon, MIN9327PKrb LLC · Rupert, IDN9329PLenders Insurance Solutions Group LLC · Ozark, MON932BVNby Productions · Bristow, VAN9331PAmra Nabil · Chaska, MNN9333PSky West Aviation Inc Trustee · Albuquerque, NMN9338PDream Home Aviation Inc · New Smyrna Beach, FLN9339PBreznik John D · Bradford, PAN933FMSouthwest Aviation Enterprises · Haslet, TXN9342PTaulbee Gregory · Sarasota, FLN9344PWheeler R Tyson · Frederick, MDN9345PRegistration Pending · Gilbert, AZRegistration pendingN9347PRegistered aircraftN93486Ablamis Roger · Los Gatos, CAN934PHRossell Holdings LLC · Astoria, ORN93505Clark Roger D · Lubbock, TXN93517Pjc700 LLC · Las Vegas, NVN9353PSmith Evan B · Mechanicsville, VAN93541Gibbs Frederick L · Flagstaff, AZN93554Pittman Randy L · Morris, ILN9356PMente Charles · Homestead, FLN93570Huffaker Kenneth Scott · Post, TXN9357ZJlh Farms Inc · Dumas, ARN9358PJeneson Tim · Ketchum, IDN9359PCarter James D · Carlton, TXN93600Babcock Barry B · Monument, CON93657Jewett Lucas D · Helena, MTN9369PLoadstone Aviation LLC · Billings, MTN9370UShort Approach LLC · Sammamish, WA
Back to AD 71-13-01 R1