Skip to content

Registered aircraft · 8,138

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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N2188RN2188r LLC · Pittsburgh, PABuilt 1969 · S/N 28-5481 N2189RSchrage James A · Danville, INBuilt 1969 · S/N 28-5482 N2189TTulsa Aviation Group Leasing LLC · Claremore, OKBuilt 1971 · S/N 28-7205041 N218TSAeronautica LLC · West Hollywood, CABuilt 1966 · S/N 28-3675 N2190TGonzales Rene V · Lampasas, TXBuilt 1971 · S/N 28-7205029 N2192TMazza Frank · Bridgeton, NJBuilt 1971 · S/N 28-7205043 N2194TNelson Donald M Jr · Fair Oaks, CABuilt 1971 · S/N 28-7205045 N2196TTilly Curtis L · Raleigh, NCBuilt 1971 · S/N 28-7205047 N2197TAdams Donald L · Huntsville, ALBuilt 1971 · S/N 28-7205048 N2199TKeith Brothers Aviation LLC · Fort Worth, TXBuilt 1971 · S/N 28-7205051 N219BJTaylor Kennedy E · Courtland, MSBuilt 1967 · S/N 28-22813 N219DBN219db LLC · Bryan, OHBuilt 1966 · S/N 28-2970 N21DSJohnson Brothers Enterprises Corp · Eldridge, ALBuilt 1968 · S/N 28-24322 N21KJCherokee LLC · Lewiston, MES/N 28-20307 N2201TCiupitu Marc P · Houston, TXBuilt 1971 · S/N 28-7105182 N2206TMullins John D · Bluff City, TNBuilt 1971 · S/N 28-7105183 N2208TThurmond Donald · Madison, GAS/N 28-7105185 N2212RFlystar Aviation LLC · Tampa, FLBuilt 1969 · S/N 28-5485 N221WA98x LLC · Caddo Mills, TXBuilt 1970 · S/N 28-26840 N2221TBannow Robert J · Marinette, WIBuilt 1971 · S/N 28-7105188 N222DLMattocks Mary E · East Amherst, NYBuilt 1971 · S/N 28-7125422 N222FLPerkins Dwight L · Oklahoma City, OKBuilt 1970 · S/N 28-26582 N222PJSchroeder James L · Rapid City, SDBuilt 1973 · S/N 28-7305259 N2230TWhite Pelican LLC · Union City, TNBuilt 1971 · S/N 28-7105189 N2239TErwin Chris L · Carson City, NVS/N 28-7125629 N223WDGilliam Preston T · Philadelphia, PABuilt 1964 · S/N 28-20366 N2240TJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1971 · S/N 28-7125625 N224BBHarris Sydnie Nicole Trustee · Austin, TXBuilt 1969 · S/N 28-25659 N224JBDutchman Leasing Services LLC · Richardson, TXBuilt 1975 · S/N 28-7505140 N224MMYoung David A · Bedford, TXBuilt 1972 · S/N 28-7225291 N2264TTofik Mahir · Cumming, GAS/N 28-7125527 N2269QN2269q LLC · West Palm Beach, FLS/N 28-7725189 N2273FCascade Aviation LLC · Burlington, WABuilt 1969 · S/N 28-25431 N22760Tuskegee Airmen National Historical Museum · Detroit, MIS/N 28-7425211 N22763Horstick Thomas E · Garnett, KSS/N 28-7425213 N2277DTaking Flight LLC · Saint Augustine, FLBuilt 1974 · S/N 28-7425225 N2277VN2277v LLC · Mesa, AZBuilt 1975 · S/N 28-7525188 N2288ZMaxwell Robert H Jr · Quincy, FLS/N 28-2196 N228WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N 28-7325243 N2290NKalika Kelly · Collinsville, ILBuilt 1971 · S/N 28-7105136 N2290QEno James C · Amherst, VABuilt 1977 · S/N 28-7725192 N2292TRegistration Pending · Waverly, IARegistration pendingBuilt 1971 · S/N 28-7125640 N2295TAhs Aero LLC · Leo, INBuilt 1971 · S/N 28-7125641 N22DVSamoilenko Nadia S · Hillsborough, NCS/N 28-1763 N22MMAerospace Quality LLC · Piggott, ARS/N 28-7305526 N22WWMouse Air LLC · Hilton Head Island, SCBuilt 1969 · S/N 28-5420 N2301TMarks Aviation LLC · Isle Of Palms, SCBuilt 1971 · S/N 28-7125545 N230XHHowell William J · Portola Valley, CAS/N 28-7425416 N2315TFaraone Nicholas Robert · Saint Petersburg, FLBuilt 1971 · S/N 28-7125499 N2318TBenedict James C II · Douglasville, GABuilt 1971 · S/N 28-7125567

Back to AD 96-10-01 R1