Skip to content

Registered aircraft · 40,471

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N98351Carufel Elizabeth R · Mesa, AZBuilt 1969 · S/N 28-26180 N98352Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276281 N98354Jin Jin Aviation LLC · Anchorage, AKBuilt 1984 · S/N 17276282 N98357Mook Jerry L · Merritt Island, FLS/N 28-26185 N9835GPiedmont Flight Inc · Winston Salem, NCBuilt 1971 · S/N 17259735 N98360Jts Aircraft LLC · Rock Hill, SCS/N 28-26184 N98363Fala Lee A · Glendale, AZS/N 28-26187 N98365Woolery Timothy A · Maryville, MOBuilt 1969 · S/N 28-26190 N9836BSoulek Paul A · Spearfish, SDBuilt 1982 · S/N 172RG1051 N9836DBuffo Perry P · Berlin, NJBuilt 1959 · S/N 22-6727 N9836GSchafhausen Mark G · Spokane, WABuilt 1971 · S/N 17259736 N98371Buhrow Chris Alan · Humble, TXBuilt 1969 · S/N 28-26195 N98372Harlow James Patrick · Liberty Hill, TXBuilt 1969 · S/N 28-26196 N98377Sloan Allen Lee · North Augusta, SCBuilt 1969 · S/N 28-26198 N98378Basta Scott C · Hayes, VABuilt 1969 · S/N 28-26199 N9837DDavis Scott · Bingham, NEBuilt 1959 · S/N 22-6728 N9837LIal Corp · Wilmington, DEBuilt 1986 · S/N 17276629 N9837WSpeare Clifford W · Saint Charles, ILBuilt 1967 · S/N 28-23344 N98380Reese Trenton · Post Falls, IDBuilt 1969 · S/N 28-26128 N98383Dunn Karl L · Hazel Green, ALBuilt 1969 · S/N 28-26202 N98384Macmillan Alfred R Jr · Salisbury, MDBuilt 1969 · S/N 28-26203 N98388Salzwedel Timothy F · New Lisbon, WIBuilt 1969 · S/N 28-26155 N98389Sale Reported · Rosenberg, TXSale reportedBuilt 1969 · S/N 28-26207 N9838BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1052 N9838GMcdonald James E · Harleyville, SCS/N 17259738 N9838VWaypoint Equipment LLC · Mckinney, TXBuilt 1974 · S/N 17264524 N9838WDutton Margaret Stephanie Executor · Mooresville, NCBuilt 1967 · S/N 28-23345 N9839DMason Andrew D · Russell, IABuilt 1959 · S/N 22-6730 N9839GLong William F · Belton, TXBuilt 1979 · S/N 17273638 N9839KP P I Consulting LLC · Gladstone, ORBuilt 1977 · S/N 28-7816198 N9839WLoiselle Matthew J · Birch Run, MIBuilt 1967 · S/N 28-23346 N983RAChristiansen Aviation LLC · Wilnington, DEBuilt 1997 · S/N 17280097 N983RBMontgomery Lorne D · Huntsville, TXBuilt 1990 · S/N 1 N984White Stevan H · Willow, AKBuilt 1963 · S/N 18-7962 N98407Choice Aviation LLC · Hamilton, MTBuilt 1985 · S/N 17276287 N9840DWard Brian P · Vonore, TNBuilt 1959 · S/N 22-6731 N9840UHeusser David G · Independence, ORBuilt 1976 · S/N AA5A0240 N9840WWings Of Grace Ministries Inc · Melbourne, FLBuilt 1967 · S/N 28-23347 N98410Mbk Leasing And Consulting LLC · Lakeland, FLBuilt 1984 · S/N 17276288 N9841GYoxall Jennifer S · Guilford, CTBuilt 1971 · S/N 17259741 N9841LHalsmer Ann Lucille · Lafayette, INBuilt 1986 · S/N 17276632 N9841WDubois Aviation Inc · Chino, CABuilt 1967 · S/N 28-23349 N98424Pfister Thomas K · Minneapolis, MNBuilt 1985 · S/N 17276289 N98426Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276290 N98428T&W Aviation LLC · Pinehurst, TXBuilt 1984 · S/N 17276291 N9842DSnider Scott E DBA · Turner, MTS/N 22-6733 N9842ESopko Michael C · Bonita, CABuilt 1975 · S/N 17702328 N9842GNighthawk N8231g LLC · Pompano Beach, FLBuilt 1971 · S/N 17259742 N9842WIreys Charles G · Tok, AKBuilt 1967 · S/N 28-23350 N9843DSlaughter Don Wayne · Farmville, NCBuilt 1959 · S/N 22-6734

Back to AD 80-04-03 R2