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.
N55679Patriot Parachute Team Inc · Blaine, MNN55682Ufer Mark · Sherburn, MNN5576JIndiana Wings Inc · Indianapolis, INN55776Jordan John R · Brawley, CAN5579YHepner Glenn L · New Port Richey, FLN557USBosco Air LLC · Idaho Falls, IDN55856Alpha Romeo Kilo Holdings Inc · Wilmington, DEN5588YBrennan Thomas F · Titusville, PAN558JTR2jm Leasing LLC · West Bloomfield, MIN558STNewport Federal · Newport Beach, CAN558TAGv Air Inc · Medford, ORN55957Blumie Thomas C · Jewett City, CTN559JRHardie George G Jr · Lancaster, CAN55BZDead Ant Aviation LLC · Wilmington, DEN55HRInternational Air Services Inc Trustee · Carson City, NVN55JSSky Kings 3 LLC · Irvine, CAN55MTKramp William J · Post Falls, IDN55RRMountain Boss Hoss Cycles Inc · Somerset, PAN55WHSvetair Inc Trustee · Wilmington, DEN56088Wild River Flying Club Inc · Saint Croix Falls, WIN56095Jk Aviation LLC · Manteca, CAN560CAJace Investment Corp · Miami, FLN560DBAnderson Aerial Spraying Svc Inc · Canby, MNN560MPJet Prop Aviation Inc · Phoenix, AZN56143Sisson Virginia B · Houston, TXN56177Bartsch Terry L · Nerstrand, MNN5618YRegistration Pending · Columbia Falls, MTRegistration pendingN561CGreene Michael E · Auburn, ALN561XHazelton Gregory C · Dallas, TXFirst renewal noticeN5622YStephan Jesse A · Richmond, TXN5627VAraujo Richard · Westport, MAN56285Knots And Attitudes LLC · Wimberley, TXN5629YTart John W · Fayetteville, NCN562CAG Gil Aviation Services LLC · Pompano Beach, FLN562GKAbney Stanley Don · Patterson, LAN562TCThekkekandam Thomas J · Greensboro, NCN562TRBig Dream LLC · Memphis, TNN5633VMcwilliams Stephen C · Hollywood, MDN56340Mja Aviation LLC · Channahon, ILN563JTRick Crum Aircraft Sales Inc · Prestonsburg, KYN563LTPrudence Aviation Group · Fort Worth, TXN563WTKlm One LLC · Wilmington, DEN5644YGantt William M · Port Orange, FLN5649YPotenza Austin · Phoenix, AZN56510Brocon Aviation LLC · West Des Moines, IAN56527Kappel Kyle D · Crossville, TNN56540Schilling Aviation Services LLC · Salina, KSN565BTGsg Aviation LLC · Fort Lauderdale, FLN565DBGolf Gear LLC · University Park, FLN565DELovestar Holdings LLC · Newark, DE
Back to AD 71-13-01 R1