Skip to content

Registered aircraft · 40,394

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

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 N9843KN9843k LLC · Melbourne, FLBuilt 1977 · S/N 28-7890187 N9843VAnderson Erik H · Trinity Center, CABuilt 1974 · S/N 17264527 N9843WBeeson Jeffrey K · Crowley, TXBuilt 1967 · S/N 28-23351 N9844SSpace Coast Aircraft Co · Merritt Island, FLBuilt 2002 · S/N 2842148 N9844VKorte Daniel J · Marlette, MIBuilt 1974 · S/N 17264528 N9844WBarson Nicholas J · Fort Pierce, FLBuilt 1967 · S/N 28-23355 N9845DAhmad Abdul Moyeed · Aiken, SCBuilt 1951 · S/N 22-6737 N9845WLipskoch Anthony P · Buhl, IDS/N 28-23356 N98463Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276294 N9846DWieler Jay H · Nome, AKFirst renewal noticeBuilt 1959 · S/N 18-6940 N9846GFord Eagles Inc · Plymouth, MIFirst renewal noticeBuilt 1971 · S/N 17259746 N9846UFerrell Joseph R Jr · Christiansburg, VABuilt 1976 · S/N AA5A0246 N9846WVladimir Martyanov · Chandler, AZBuilt 1967 · S/N 28-23357 N98477Registered aircraftBuilt 1985 · S/N 17276296 N9847GPilot In Command Academy · Miami, FLBuilt 1971 · S/N 17259747 N9847LJoerithan & Mp Aviation LLC · Whittier, CABuilt 1986 · S/N 17276635 N9847PFell William P · Anchorage, AKBuilt 1976 · S/N 18-7609037 N9847VWinder Editha S · Columbus, NMBuilt 1974 · S/N 17264530 N9847WLukas Craig S · Omaha, NEBuilt 1967 · S/N 28-23359 N98485Amelia Reid Aviation LLC · San Jose, CABuilt 1985 · S/N 17276299 N9848GRicci Mark P · Waterford, MIBuilt 1971 · S/N 17259748 N9848JLanham David R · Visalia, CABuilt 1980 · S/N 17273934 N9848UHenley Jimmy · Linden, NCBuilt 1976 · S/N AA5A0248 N9848VSuperhawk Flight LLC · Plano, TXS/N 17264531 N98492Henry Mark Alan · Dickinson, TXBuilt 1985 · S/N 17276300 N98494Noggle William L · Warthen, GABuilt 1984 · S/N 17276301

Back to AD 79-10-03 R2