OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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.

N20DZWeathers Air LLC · Longwood, FLBuilt 1986 · S/N 615N20EA4-D Aviation Consulting LLC · Wilmington, DEBuilt 2001 · S/N 007N20EHUnzicker Keith R · Benson, ILBuilt 1966 · S/N 1090N20ELJrhav LLC · Chassell, MIS/N 622N20EMReifert Todd · Louisville, KYBuilt 1981 · S/N 0001N20EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12513N20ETClear Skies Avionics Inc · Clearwater, FLS/N 621N20EUWerking John William III · New Windsor, MDS/N 628N20FLowden Howard J · Rome, GABuilt 1965 · S/N TD-623N20FCLge Flying Club Inc · Marietta, GABuilt 1970 · S/N 18260314N20FHSky Solutions LLC · Detroit, MIBuilt 2008 · S/N 12348N20FKJohnston Brian · Bethany Beach, DES/N 637N20FSDahm Douglas W · Discovery Bay, CAS/N 23122N20FVRogers Robert D Jr · Keller, TXBuilt 1986 · S/N 642N20GDCoffey James R · Evergreen, COBuilt 1957 · S/N D-5116N20GGHofer Danny C · Huron, SDBuilt 1978 · S/N 28-7916032N20GKHashmi Aijaz · Riverside, CAS/N 646N20GUBaldree Christian Blair · Roseville, CAS/N 655N20GWWyatt John B · Culpeper, VABuilt 1977 · S/N 1N20HBMontana Sky Aircraft LLC · Kalispell, MTS/N 18262945N20HMMullett Peter C · Carbondale, COBuilt 1975 · S/N E-750N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306N20HYTack John A · Wasilla, AKBuilt 1998 · S/N 2001N20JBBastian Richard L · Burns, WYBuilt 1974 · S/N 1-0031N20JCJcmc Inc · Junction City, KSBuilt 1955 · S/N 22-2879N20JDDesroches John · Scottsdale, AZBuilt 1962 · S/N 28-375N20JEReid Keith D · Vinemont, ALBuilt 1996 · S/N 20N20JMWaeltz Mark A · Lantana, FLBuilt 1967 · S/N 28-4393N20JNGana Trucking & Excavating Inc · Martell, NES/N 340A0050N20JPJohnson Leif M · Midlothian, TXBuilt 1993 · S/N 783N20JSOyaski Michael F · Ebensburg, PABuilt 1975 · S/N 18263751N20JWRocky Mountain Triangle LLC · Castle Rock, COBuilt 1962 · S/N TC-258N20JZWest William D · Newton, NCBuilt 1986 · S/N 652N20KBAnderson David R · Sycamore, ILBuilt 1976 · S/N M-2-570N20KGAdspitalny LLC · Waynesville, MOBuilt 1986 · S/N 668N20KHN20kh LLC · Clewiston, FLBuilt 2021 · S/N 18283153N20KJOxford Flying Club Inc · Oxford, CTBuilt 1998 · S/N 18280143N20KLBuell Kenneth B · Port Orange, FLBuilt 1986 · S/N 669N20KNShaw William C · Carmel, NYS/N 682N20KPHulsey Ryan A · Cleveland, GAS/N 683N20LAPet Care Centers Of America LLC · Helena, MTS/N 11699N20LEQuality Leasing Inc · Niceville, FLBuilt 1994 · S/N 1809080N20LFFerguson Michael W · Burlington, WIBuilt 2020 · S/N 91029N20LGYerena Mario Cesar Gutierrez · Bethel Island, CABuilt 1968 · S/N 28R-30491N20LKHobert Robert W Trustee · Penn Valley, CABuilt 2001 · S/N 21299N20LLFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990119N20LSStaheli Lee · Kiana, AKBuilt 2020 · S/N 14393N20LTSeagull Services LLC · San Rafael, CABuilt 2003 · S/N 26015CN20MLong David M · Schaumburg, ILBuilt 1983 · S/N BG-204N20MCOpie Aviation Services LLC · Nashville, NCBuilt 1979 · S/N 25-0067
Back to AD 2007-04-19 R1