AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N3355BGar Aviation Inc · Lexington, ORN3355EMiddletown Regional Flight Training Institute LLC · Middletown, OHN3355RSkyhawks Flying Club Inc · Canton, SDN3355WBland Joseph G · Gainesville, TXN3355ZSmp Wind River LLC · Thermopolis, WYN33560Sherron Jim Kemp IV · Raleigh, NCN33562Aiken Flyers LLC · Aiken, SCN33563Cape Fear Aviation Services LLC · Fayetteville, NCN33565James Harris · Helotes, TXN33566Roebke Karen L Trustee · Gilbert, AZN33567R Merritt Investments Inc · Jonesville, MIN33568Papoi Benjamin F · Phoenix, MDN3356DShapiro David M · Homer, AKN3356FShroyer Scott E · Peyton, CON3356MH E P Flying Club Corp · Wyoming, MNN3356SBbt Inc · Wilmington, DEN3356TCarlin Joseph A Jr · Rapid City, SDN3356WFive Six Whiskey LLC · Plainfield, INN33575Nationwide Aviation LLC · Hudson Oaks, TXN3357DHodel Lawrence E · Hayden, IDN3357KNewman Steve M · Portland, ORN3357LMark II Aviation LLC · Corvallis, MTN3357THigh West Aero LLC · Broadus, MTN3357URunway Ventures LLC · Salida, CON3357ZHannon Harland N · Big Lake, AKN3358AWagner Richard L · Willis, TXN3358RHaydukovich Steven J · Phoenix, AZN3358UBratcher Michael · Elizabethtown, KYN33595N33595 Cherokee LLC · Austin, TXN33599A & Aviation LLC · Pinellas Park, FLN3359FHughes John · Almira, WAN3359MWarren Wesley L · Coeur D Alene, IDN3359TDuquette Robert R · Elfrida, AZN3359WMcmaster James R II · Bath, PAN3359ZKistler Stephen M Trustee · Monument, KSN335ACRegistration Pending · Fort Pierce, FLRegistration pendingN335APAndy Petree Inc · Denver, NCN335BBVantrease David A · Wills Point, TXN335BFSouthern Aircraft Consultancy Inc Trustee · Casper, WYN335BGBowling Green Flight Center LLC · Bowling Green, OHN335BWThorp T-18 Ri LLC · Foster, RIFirst renewal noticeN335CBAlcala Miguel Arturo Astorga · Gilbert, AZN335CMPura Plastic Surgery LLC · Doral, FLN335DDJab Aviation Inc · Wilmington, DEN335DPAdvanced Aviation Group LLC · Frederick, MDN335DSWhitaker Martin · Portland, MEN335FDRoy Martin P · Chehalis, WAN335HCOtis Stephen H · Mcalester, OKN335HPOlympus Leasing LLC · Bremerton, WAN335JAAstrologo Joseph A Jr · Tullahoma, TN
Back to AD 2007-04-19 R1