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.

N510FHCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841179N510GN510g LLC · Venice, FLS/N 660-320-404FBN510HRBrian Investments LLC · Elizabethtown, NCBuilt 1998 · S/N 4223-4N510KSNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282177N510LPSouthern Cross Aviation LLC · Parker, AZBuilt 2003 · S/N 172S9510N510LSRegistration Pending · Nashville, TNRegistration pendingBuilt 2002 · S/N 899-2002N510MARegistered aircraftBuilt 2005 · S/N 2322N510NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2010 · S/N 172S10952N510NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C1001N510PCPaton Jamie D · Clearwater, FLS/N 1488N510RGGrubbs Randall D · Heber Springs, ARBuilt 2025 · S/N VANSRV10L54040791N510RKKnapp Russell · Groveland, FLBuilt 2024 · S/N 41162N510RVDeering Casey T · San Angelo, TXBuilt 2008 · S/N 40326N510SFGibson William V II · Aberdeen, MSBuilt 2008 · S/N 001N510SLBeery Roofing & Redesign LLC · Deland, FLS/N 18282153N510TCSkyview Aviation LLC · Hartwell, GAS/N E-1469N510TFLang Eric O · Oklahoma City, OKBuilt 1978 · S/N 340A0499N510THRegistration Pending · Oxford, CTRegistration pendingBuilt 1975 · S/N 28R-7535221N510TRAltamira Flying Club Inc · Round Rock, TXBuilt 2003 · S/N 18281200N510UBoard Of Regents University Of Oklahoma · Norman, OKBuilt 2024 · S/N 4496588N510WFFuel Center Plus Inc · Silver City, NMBuilt 1980 · S/N 21064140N510WHCerniglia Paul J · Monroe Township, NJBuilt 1963 · S/N 310H0142N51101Sweitz-Air Iinc · Stewartstown, PAS/N 23985N5110DBlaine Wright Inc · Polson, MTBuilt 1958 · S/N 51210N5110EHartley Kirk R · Palmer, AKBuilt 1958 · S/N 50410N5110GN5110g LLC · Orlando, FLS/N 28-23211N5110HBuxton S · Mount Pleasant, SCBuilt 1948 · S/N 14-115N5110JArbogast Matthew G · Ooltewah, TNBuilt 1975 · S/N 310R0230N5110PGray William · Broken Arrow, OKBuilt 1958 · S/N 24-120N5110UGiese Shari L · Wasilla, AKBuilt 1964 · S/N 2060110N5110XT & M Aerial Spraying · Garland, NCBuilt 1969 · S/N 192N5111BWhittaker Darrel S · Chapmansboro, TNBuilt 1998 · S/N 4003N5111GHammond Jason · Nevada City, CABuilt 1971 · S/N 18260746N5111JValiair Ltd Co Trustee · Casper, WYBuilt 1975 · S/N 310R0231N5111RAlpine Aviation LLC · Oasis, IDBuilt 1974 · S/N MB-645N5111SC And A Aviation Inc · Baltimore, MDBuilt 1971 · S/N 28-7105130N5112DScootair LLC · Alburgh, VTBuilt 1958 · S/N 51212N5112ETail Wheel Excursion LLC · Redmond, ORBuilt 1958 · S/N 50412N5112GCrawford Law Pllc · Selah, WABuilt 1967 · S/N 18258496N5112HDefendorf Nelson W · Anchorage, AKS/N 14-118N5112LRyan Lowe Aviation · Costa Mesa, CABuilt 1967 · S/N 28-4394N5112NRcr Aviation LLC · Cave Creek, AZBuilt 1980 · S/N 18267524N5112VMertz Harry Z · Castle Rock, COBuilt 1961 · S/N SP-12N5112WShulman Scott · Hillsborough, NHS/N 28-128N5113KParrillo Development And Real Estate LLC · Sarasota, FLBuilt 1979 · S/N 17272455N5113LTessos Air Service Inc · Wilmington, DEBuilt 1968 · S/N 28-5083N5113QTri-County Aviation LLC · Lawrenceburg, TNS/N 17261754N5113RHamaker Nevada C · Bothell, WABuilt 1974 · S/N MB-647N5114DCasillas Justin M · Liberty, TXBuilt 1958 · S/N 51214N5114EVinton John H · Mullen, NEBuilt 1959 · S/N 50414
Back to AD 2007-04-19 R1