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.
N737WKInternational Air Services Inc Trustee · Carson City, NVN738CFishgold Valerie Trustee · Scottsdale, AZN7392VBrown Mill Ranch LLC · Lamar, CON739VJ739vj LLC · Brooklyn, NYN73CZBm Air LLC · Anaconda, MTN73DNMurdoc Aviation LLC · Destin, FLN73LKMoore David E · Stuart, FLN73RTRegent Trust Corp Trustee · Wichita, KSN73RWSeppala Joel H · Taylors, SCN73WHBumble Bee Aviation LLC · Brookfield, WIN740HCVuksanovic David A · Fountain Hills, AZN7411SNaik Narayan · Claremore, OKN74199Aldrich Curtiss R · Aguila, AZN7419SKcantarano LLC · Mukilteo, WAN741CHDelta Holding And Investment Company LLC · Wilmington, DEN741TDCovey Rise LLC · Charlotte, NCN7424A24 Alpha LLC · North Salt Lake, UTN7425SSweeney Sean M · Reunion, FLN7426LWright Air Service Inc · Fairbanks, AKN742HMBennett Aviation LLC · New York, NYN7432LStandard Air LLC · West Linn, ORN7434LIsland Wings Inc · Fort Lauderdale, FLN7438SFrana Joel A · Fort Myers, FLN7441SKp Stunt Productions Inc · Burlington, NDN744JCAck-Pg-LLC · Charlestown, MAN744RVAustin Aviation LLC · Maumelle, ARN745AALarson Stephen Blair · Raleigh, NCN745KLNby Productions · Bristow, VAN746AJNesta Joseph A · Kelleys Island, OHN746RRSolis Inc LLC · Alton, NHN7471AGo Dog Go LLC · St George, UTN7471BRegistered aircraftN747ATHaueisen Jessica · Franklin, GAN747CGAir Americus LLC · Johns Creek, GAN747HSale Reported · Santa Rosa, CASale reportedN747MEEvans Mark W · Camillus, NYN747TATatonka Aviation LLC · Irvine, CAN747THPhilburto Consulting Ltd · Telluride, CON7482WSkys Edge Aviation LLC · Midland, TXN748NPBelle Island Management LLC · Fort Lauderdale, FLN748PSHurst Aviation LLC · Jackson, MON74932Ruocco 220 LLC · Escondido, CAN7496SSmith Linda L · Port Charlotte, FLN74972H&H Aircraft LLC · Grey Eagle, MNN749RSAery Aviation LLC · Wilmington, DEN74BBHy Aviation LLC · San Juan, PRN74CPCivil Air Patrol · Maxwell Afb, ALN74DDN74dd Inc · Apalachicola, FLN74GKFerrell Mobile Homes Inc · Benton, MON74LM74lm Travel LLC · Austin, TX
Back to AD 71-13-01 R1