AD 71-13-01 R1
Registered aircraft · 6,915
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.
N283GTKinz Air LLC · Winter Springs, FLN283SSSmith Scott R · Grand Junction, CON2843GPopop Corp · Portland, ORN2847JMoses Henry A · Uvalde, TXN284HBAviatiek LLC · Hudsonville, MIN285CPCivil Air Patrol · Maxwell Afb, ALN285DVJohnson Jeffrey L · Fargo, NDN285JLLink Air Service LLC · Minong, WIN285MEN285me Holding LLC · Palm City, FLN285PSShavinsky John E · Fairfield, CTN286CPCivil Air Patrol · Montgomery, ALN288JYNational Aircraft Leasing Corp · Greenville, DEN288TGSky West Aviation Inc Trustee · Albuquerque, NMN288WEAviators LLC · Edina, MNN28934Johnson Grant M · Odessa, FLN289JGNex Gen Paving Inc · Sanford, TXN289MJJ-Com Aviation LLC · Richland, MSN289PCdr Development LLC · Houston, TXN28BEHaas Edward F · Batesville, ARN28DFGlobal Avionics LLC · Downey, CAN28HSStone Michael S · Chamois, MON28JKTorps LLC · Southlake, TXN28KEGrant Aviation Inc · Anchorage, AKN28PVJordak Thomas · Simpsonville, SCN28PZAsa Obion LLC · Union City, TNN2904PRandall Airlines LLC · Wendell, NCN2908YAnco Air Inc · Weston, FLN290DYZumm Thomas Lawrence · Wheaton, ILN290HLynco Air LLC · Venice, FLN290MSurging Skyward Inc · Newtown, PAN291FRCon Air Aviation LLC · Borger, TXN291MWHeritage Aviation Management Ltd · Conroe, TXN292HCarlisle Services LLC · Pine Mountain, GAN292SMartin James David · Graford, TXN2932QK & W Aviation LLC · Jackson, TNN2943QAurand Bradley · Selinsgrove, PAN2947Moran M Michael · Chico, CAN295CSLarsen Levitation LLC · Wasilla, AKN295MRCarrera Air LLC · Tampa, FLN295SKds Aviation LLC · Normal, ILN29623Swann Hardy · Nacogdoches, TXN2968LWills Terry W · Cedar Park, TXN2969QOsullivan James S · Palo Alto, CAN296CHTgl Partners LLC · Plant City, FLN296CS1928 LLC · Salmon, IDN296DEDouble T Flyers LLC · Fort Worth, TXN296FSD7 Roofing LLC · New Baden, ILN296PBChurch Aviation LLC · Christmas Valley, ORN296PCCarlyle Air LLC · Morristown, TNN297BCUnderwood David · Sarasota, FLFirst renewal notice
Back to AD 71-13-01 R1