Registered aircraft · 108,428

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

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

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.

N190MEMenagerie Enterprises Inc DBA · Denison, TXBuilt 2012 · S/N 172S11190 N190P98 Mike LLC · Hayden, IDBuilt 1964 · S/N P206-0012 N190QMcgilvray Saxon · Helena, MTBuilt 1964 · S/N D-7551 N190RROrr John C · Longmont, COBuilt 1997 · S/N 23039 N190RVMccormick David E · Antioch, ILBuilt 1998 · S/N 30424 N190SEAlbritton Randy L · Camas, WABuilt 2021 · S/N 101 N190YSalo Mark W · Poulsbo, WABuilt 2005 · S/N 23085C N19103Mashburn Paul M · Cumming, GABuilt 1976 · S/N 17702557 N1910MMob Aviation USA LLC · Auburndale, FLBuilt 1975 · S/N 18264475 N1910PWesley Gary J · Moorland, IABuilt 1955 · S/N 22-2657 N1910TBrown James E · Wind Lake, WIBuilt 1971 · S/N 28-7125464 N1910YPeabody Riley A · Minnetonka, MNBuilt 1964 · S/N 205 N19119Rose Randy J · Egg Harbor, WIBuilt 1976 · S/N 17702559 N1911HAdair Aviation LLC · Mountain Home, ARBuilt 1980 · S/N R18201550 N1911JD M C Aviation LLC · Jennings, LABuilt 1971 · S/N E-298 N1911PWalker Raymond Lee · Saint Charles, MIBuilt 1955 · S/N 22-2590 N1911TSnp Aviation LLC · Avoca, IABuilt 1971 · S/N 28-7125412 N1911VLefort Charles J · Redding, CABuilt 1974 · S/N 28-7405103 N1911XSs Aviation LLC · Preston, IDBuilt 1965 · S/N 18256011 N1911Y1911y Aviation LLC · Windsor, ILBuilt 2025 · S/N 42336 N1912LRegistered aircraftBuilt 1976 · S/N E-866 N1912PSojourner Field LLC · Kouts, INBuilt 2014 · S/N 22483 N1912THillman Motors Inc · Winter Haven, FLBuilt 1971 · S/N 28R-7135130 N1912XWhite Charles S · Anacortes, WABuilt 1965 · S/N 18256012 N1912YFrokjer Dean C · Saint Croix Falls, WIBuilt 1964 · S/N 207 N1913HOllie And Wally Airlines LLC · Auburn, WABuilt 1977 · S/N 28-7716061 N1913LBas Part Sales LLC · Greeley, COBuilt 1976 · S/N CE-656 N1913TWilliams Ronald P · Woodway, TXBuilt 1971 · S/N 28-7125474 N1913XYates Craig J · Indialantic, FLBuilt 1965 · S/N 18256013 N1913YSchmitt William Joseph · Santa Cruz, CABuilt 1964 · S/N 208 N1914HMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7716062 N1914LDeakins Glenn F · Ringgold, GAS/N MB-803 N1914VStephens Thomas E · Blacklick, OHBuilt 1974 · S/N 17263792 N1915AMercatoris Robert B · Meadville, PABuilt 1952 · S/N 18-1756 N1915PParker Joshua J · Hawley, TXBuilt 1955 · S/N 22-2662 N1915TAeromx LLC · West Jefferson, OHBuilt 1971 · S/N 28R-7135132 N1915WPasha Mohammad A · Muscatine, IABuilt 1971 · S/N 310Q0429 N1915YJordan S Connor · Elizabeth City, NCBuilt 1964 · S/N 210 N1916Rauser Richard A Trustee · Cottonwood, CABuilt 1974 · S/N 18263299 N1916JCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13182 N1916XCannon Aviation LLC · Morgan, UTBuilt 1965 · S/N 18256016 N1916YLarsen Adam P · Gresham, ORBuilt 1964 · S/N 211 N1917LEpiphany Airmotive LLC · Frisco, TXBuilt 1976 · S/N M-1817 N1917UPinewood Homes LLC · Hayward, WIBuilt 1969 · S/N 185-1588 N1917YMock Joseph R · Huntsville, TXBuilt 1964 · S/N 212 N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668 N1918LBurt Christopher James · Leesport, PABuilt 1976 · S/N M-1813 N1918MWalker Stephen L Trustee · Andover, KSBuilt 1975 · S/N 18264481 N1918VCampbell Kevin A · Grayville, ILBuilt 1974 · S/N 17263794 N1918XCarlson Brent A · Shelley, IDBuilt 1965 · S/N 18256018

Back to AD 2007-04-19 R1