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.

N44997Faulkner 44 LLC · Wilmington, DEBuilt 2012 · S/N 13314N4499JWiblemo Craig B · Fallbrook, CABuilt 1967 · S/N 28-22920N4499PTls Aviation · Marysville, WABuilt 1961 · S/N 23-2022N4499WUrban James R · Pierre, SDBuilt 1965 · S/N 28-2911N449AArcher Aero LLC · Wilmington, DEBuilt 2014 · S/N 2843798N449AGKershner Jordan · Malcolm, NEBuilt 1967 · S/N 17700344N449AK3 Danes And A Moose LLC · Granada Hills, CABuilt 2023 · S/N 3412N449ASConcho Aviation LLC · Sterling City, TXBuilt 2003 · S/N 10108N449BASpitzer Helicopter LLC · Woodland Hills, CABuilt 2013 · S/N 2265N449BCMcbride Richard A · Deer Park, WAFirst renewal noticeBuilt 2007 · S/N 1681N449BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496608N449CD9 Robin LLC · Wilmington, DEBuilt 2012 · S/N 13354N449CNSpeedo Air LLC · Hales Location, NHS/N 10431N449CSHorizon Flight Center LLC · Chesapeake, VABuilt 2017 · S/N 172S12025N449DAArford Dennis C · Athens, GABuilt 2017 · S/N 22124N449DMMccord David B · Chico, CABuilt 1998 · S/N 001N449EWWilliams Ethan B Trustee · Wasilla, AKBuilt 2012 · S/N 001N449FAAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3683N449JGHerlihy John J · Arroyo Grande, CABuilt 1979 · S/N 61P06567963304N449LMontana Hotel LLC · Providence, UTBuilt 1993 · S/N 2075N449LLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N EA-332N449MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 4496534N449MSMs Aviation LLC · Los Angeles, CABuilt 2017 · S/N 14081N449PAChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496185N449PMMullenbach Michael R · Saint Ansgar, IABuilt 1999 · S/N 1466N449PSMid Atlanta Air Museum · Reading, PABuilt 1974 · S/N 12449N449RV T Whitlock Inc · Lake City, SCBuilt 2003 · S/N 10112N449RMRocky Mountain College · Billings, MTBuilt 2024 · S/N 28020198N449RVRobinson Stewart · San Jacinto, CABuilt 1998 · S/N 20449N449SFKyle Allyn B · Snohomish, WABuilt 1957 · S/N 50013N449SPGolden Eagle Flying Club Ltd · West Islip, NYBuilt 1999 · S/N 172S8315N449TSmallwood David · Oak Ridge, TNBuilt 1970 · S/N D-9153N449VYKirkham Matthew · Cazenovia, WIBuilt 1973 · S/N 18262199N449WFGlenns Super Cub LLC · Fort Lauderdale, FLS/N 18-7773N44ARounds Don DBA · Waller, TXS/N G-723N44ABAnthony Ronald W · Claremont, CABuilt 1975 · S/N 22-1196N44ADTice Logan Edward · Noblesville, INBuilt 1979 · S/N 123ADN44AGVanderpool Gary W · Alamo, TXBuilt 1966 · S/N 188-0138N44AKAvcom Co · Friday Harbor, WABuilt 1978 · S/N 61P-0481-194N44AYPartin Kathy L · Nacogdoches, TXS/N 28R-7535012N44BKBirum Kevin M · Kingston, WABuilt 2001 · S/N 5573N44BLBoehr Greg J · Mc Cool Junction, NES/N 17256854N44BPAircraft Partner Holdings Inc Trustee · BerlinBuilt 2011 · S/N 13215N44BWMariani Aviation Services LLC · Vero Beach, FLBuilt 1987 · S/N 219N44CCoyne Greg · Hondo, TXBuilt 1979 · S/N P21000311N44CAWiley Commercial Property Consulting Inc · Aitkin, MNBuilt 1980 · S/N R18201556N44CCColumbia Club Aero LLC · East Wenatchee, WABuilt 1971 · S/N 18260646N44CFFly Low Aviation LLC · Smithville, MSS/N 21059764N44CMRussell Stephen J · Chester, VTBuilt 1969 · S/N D-8927N44CUAirstar Aviation LLC · Manawa, WIBuilt 1976 · S/N 17268037
Back to AD 2007-04-19 R1