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

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.

N2357TB & R Aviation LLC · Pine Knoll Shores, NCBuilt 1961 · S/N NAV-4-2357 N2357XScavera Kevin · Madras, ORBuilt 1965 · S/N 18256257 N2357ZUsda Aphis Ws Atoc · Cedar City, UTBuilt 1980 · S/N 18-8109016 N23585Smile By Air LLC · Columbus, OHBuilt 1975 · S/N 32R-7680007 N23589High Times Adventure Co LLC · Columbiana, ALBuilt 1977 · S/N TH-889 N2358FEast County Communications Inc · Hurricane, UTBuilt 1965 · S/N 21058558 N2358KSmith Aeromotive Charters Inc · Excelsior, MNBuilt 1997 · S/N TH-1827 N2358LSimpson Timothy A · Niles, MIBuilt 1963 · S/N M-196 N2358QBertrand Jason A · Seattle, WAS/N M-427 N2358SBornhoft Jerome T · Riverton, WYBuilt 1979 · S/N R18201333 N2358TNewcom Bradly C · Hanson, KYBuilt 1961 · S/N NAV-4-2358 N2358ZBrinegar Matthew D · North Tustin, CABuilt 1962 · S/N M-70 N2359FSheldon David E Trustee · Idaho Falls, IDBuilt 1964 · S/N 21058559 N2359LJ & M Baling Inc · Farmington, NMBuilt 1998 · S/N E-3159 N2359PRyan Good Aviation LLC · Sioux Falls, SDBuilt 1955 · S/N 18-4245 N2359QBean Glen A · Damascus, ORS/N M-428 N2359RTide City Air LLC · Germantown, TNBuilt 1964 · S/N 18255459 N2359TChopco Ltd · Columbus, OHS/N 2359 N2359UUden Plumbing & Heating Inc · Grand Island, NES/N 28-7911305 N2359XHarker Charles R · Suwanee, GABuilt 1965 · S/N 18256259 N2359YWadsworth Edwin Allen · Sarasota, FLBuilt 1967 · S/N 17700159 N235AADifferent Auto LLC · Twin Falls, IDBuilt 1959 · S/N D-5967 N235AKJain Arun J · Palmer, AKBuilt 1983 · S/N 7448C N235ALStinair LLC · Millville, CABuilt 2000 · S/N 23067C N235AZSchlenker David D · Marine St Crx, MNBuilt 1980 · S/N R18201658 N235BBMidland Truss Inc · Wagener, SCBuilt 1973 · S/N 28-7410048 N235BGMcdonald Russell · Rock Island, WAS/N 18002C N235BKWagner Nathan D · Dane, WIBuilt 1998 · S/N 011 N235BPPaulson Brent Linn · Henderson, NVBuilt 1966 · S/N 2810776 N235CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13084 N235CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881504 N235CFNathans David · Chambersburg, PABuilt 1963 · S/N 28-10155 N235CMReed Michael · Chino Hills, CAS/N 32-786 N235CPVee Christopher Shawn · East Bethel, MNBuilt 1976 · S/N 28-7610076 N235CRRegistration Pending · Killeen, TXRegistration pendingBuilt 1973 · S/N 28-7310099 N235CWGreen Michael L · Midlothian, VAS/N 18009C N235DRegistration Pending · Mead, CORegistration pendingBuilt 1978 · S/N TJ-134 N235DAMarc Aircraft Holding LLC · Soldotna, AKS/N 27-582 N235DBDelledera Steven D · Livermore, CABuilt 1966 · S/N 28-10722 N235DEAcro Aviation LLC · Littleton, COBuilt 1948 · S/N 108-4566 N235DGProp Air Inc · Allen Park, MIBuilt 1969 · S/N 28-11097 N235DMDouble W Air LLC · Salt Lake City, UTBuilt 1978 · S/N 7247C N235EMcfarland Joel Cable · East Earl, PABuilt 1963 · S/N D-7162 N235EDBeggs Kevin Robert · Lincolnton, GABuilt 1963 · S/N 28-10097 N235EGHch Aircraft LLC · El Paso, TXBuilt 1985 · S/N EA-443 N235EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13099 N235ESQualitair LLC Trustee · MichelstadtBuilt 2000 · S/N 18046C N235FPoirot Steven James · Anchorage, AKBuilt 1967 · S/N 28-10875 N235FSOehmke Adam A · Camarillo, CABuilt 1988 · S/N 4052C N235FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2841285

Back to AD 2007-04-19 R1