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.
N6044YPinnock Charles W · Port St Lucie, FLN6044ZMunger Stanley E · Sioux City, IAN60458Lindsarwatt Air LLC · Grand Junction, CON6045BPalmetto Flats LLC · Fort Pierce, FLN6045COrange County Sheriffs Department Rnsp · Santa Ana, CAN6045UPronghorn Aviation LLC · Lubbock, TXN6046GBeyond Potential LLC · Tucson, AZN6046YWells Douglas A · Chino, CAN6048THeartland Horseshoeing School Inc · Lamar, MON6049KDeck Chair Air LLC · Bend, ORN6049SJ Birds LLC · Peyton, CON6049VBlackbird Alliance LLC · Rancho Mirage, CAN604AGSgflight5 LLC · Lake Zurich, ILN604CPCivil Air Patrol · Maxwell Afb, ALN604DCRomee Aviation LLC · Dallas, TXN6050Union Valley Petroleum Corp · Enid, OKN6052CDouble D Air LLC · Lake In The Hills, ILN6052JBrite Angel Landing Inc · Mccall, IDN6052YCentral Kentucky Aviation Inc · Bardstown, KYN60533K2 Investment Fund LLC · Zephyr Cove, NVN6053CTaylor Travis E · Olathe, CON6056EInfinity Flight Ltd · Wilmington, DEN60587Jbb Enterprises LLC · Lewes, DEN6058PJarrett Holdings LLC · Wink, TXN6058YEltgroth Peter G · Livermore, CAN6059ULt-Marine/Aviation Partners LLC · Lakeway, TXN6059YCrazy Mountain Legacy LLC · Missoula, MTN605SGN605sg Aviation LLC · Wilmington, DEN6060NNord Excavation Inc · Rigby, IDN6062GSplatman Aviation LLC · North Salt Lake, UTN6062YJahba LLC · Coral Springs, FLN6063KCanyon Construction Co · Elko, NVN6064MW E Aviation LLC · Fort Worth, TXN6064PWise Security Systems LLC · Myrtle Point, ORN6065RSouthern Tier Express Inc · Andover, NYN606CACv Wings LLC · Canby, MNN606ZZPiper Dreams LLC · Nantucket, MAN6071ZJones Wayne A · Miami, FLN60722Reynolds Timothy · Albuquerque, NMN6072TThibault Dominic · Titusville, FLN6075MLz Max Air LLC · Atlanta, GAN6076TFauntleroy David W Trustee · Geneva, ILN6076UJr Squared Aviation LLC · Lewes, DEN6076YRemuda San Pedro LLC · San Antonio, TXN6078TSouthern Aircraft Consultancy Inc Trustee · Casper, WYN6079DBird Properties LLC · Roosevelt, UTN607CBank Of Utah Trustee · Salt Lake City, UTN607DMAdx LLC · Saint Marys, KSN607EDUnimax Aviation LLC · Portland, ORN607JWMid-South Bulk Services Inc · West Memphis, AR
Back to AD 71-13-01 R1