Skip to content

Registered aircraft · 54,019

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N19022Delta Lima Foxtrot LLC · Kalispell, MTBuilt 1980 · S/N 18053176 N1902XKelly Jerome · Babbitt, MNBuilt 1965 · S/N 18256002 N1902Z1st Stop Aviation Services And Consulting LLC · Tulsa, OKS/N 15059702 N19030Butler William D · Wichita Falls, TXBuilt 1972 · S/N 15074107 N19032Courtney John E · Perry, FLBuilt 1972 · S/N 15074109 N19033Caldwell Richard Newton Jr · Whitewright, TXBuilt 1972 · S/N 15074110 N19037Tims Air Adventure LLC · Waterville, WABuilt 1972 · S/N 15074114 N19039Ludwig Thomas Randall · Hesperia, CABuilt 1972 · S/N 15074116 N1903QMatter Gregory · Sherman, TXBuilt 1972 · S/N 177RG0303 N1903XAivcon Inc · Charlevoix, MIBuilt 1965 · S/N 18256003 N1903ZBuzby Justin T · Wasilla, AKBuilt 1962 · S/N 15059703 N19040Breese Charles F · Owasso, OKBuilt 1972 · S/N 15074117 N19044Kieselbach Wayne L · Mason, MIBuilt 1972 · S/N 15074121 N19045Spryn Charles J W · Butler, PABuilt 1972 · S/N 15074122 N19047Machado David A · Elk Grove, CABuilt 1972 · S/N 15074124 N1904FRoberts Walter A · Emery, SDBuilt 1966 · S/N 18257699 N1904UAircraft Partner Holdings Inc Trustee · BerlinBuilt 1950 · S/N 7592 N1904ZNorman John W · Burlington, WABuilt 1962 · S/N 15059704 N19054Lawris Inc · Wilmington, DEBuilt 1972 · S/N 15074129 N1905ULeichtfuss Brad · Lake Havasu City, AZBuilt 1973 · S/N U20602275 N1905VNew Horizons Aviation Inc · Goshen, INBuilt 1974 · S/N 17263788 N19061Mccauley Aviation Inc · Springfield, TNBuilt 1972 · S/N 15074134 N19063Barbers Point Flight School LLC · Kapolei, HIBuilt 1972 · S/N 15074135 N19066Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 15074138 N1906CHolcomb Garry M · Point, TXS/N 26051 N1906FP206-1 LLC · Carrollton, GABuilt 1964 · S/N P206-0001 N1906VN46132 LLC · Kalispell, MTBuilt 1974 · S/N 17263789 N1906XLawless Mark · Des Moines, IABuilt 1965 · S/N 18256006 N19078Freefall Express Inc · New Paltz, NYBuilt 1972 · S/N 15074149 N1907QSimmons Marilyn K · Wilmington, DEBuilt 1972 · S/N 177RG0307 N1907ZMontcalm Aviation LLC · Coral, MIBuilt 1962 · S/N 15059707 N19080Stypinski Stephen M · Yucca Valley, CABuilt 1972 · S/N 15074151 N19085Fountain Steven J · Moscow, IDBuilt 1972 · S/N 15074156 N19087Greene Zachary R · Danville, VABuilt 1972 · S/N 15074158 N1908FMccloskey Cynthia · Matthews, NCBuilt 1973 · S/N 17256493 N1908MAirtrader LLC · Hornersville, MOBuilt 1975 · S/N 18264473 N19093Gedney Douglas Kevin · Issaquah, WAS/N 17702556 N19094Merlin Soaring Association · Amelia Court House, VABuilt 1972 · S/N 15074164 N1909CSwanke Mark · West Ossipee, NHBuilt 1953 · S/N 26054 N1909FMarshal Group LLC · Lucedale, MSBuilt 1964 · S/N P17257189 N1909QHarper Donald W · Odenton, MDBuilt 1972 · S/N 177RG0309 N1909XBowie Dana M · England, ARBuilt 1965 · S/N 18256009 N1909ZGecy Robert G · Simpsonville, SCS/N 15059709 N190DFFuller Darel C · Moses Lake, WABuilt 1952 · S/N 7786 N190DMMcintyre Donald F · Fort Gratiot, MIBuilt 1978 · S/N 18266049 N190ECMiller Dennis G · Galena, ILFirst renewal noticeBuilt 1951 · S/N 7653 N190FCook James H · Brookings, ORBuilt 1958 · S/N 46366 N190LSSkinner Lawrence W · Fort Myers, FLBuilt 1950 · S/N 7542 N190P98 Mike LLC · Hayden, IDBuilt 1964 · S/N P206-0012 N190SMelichar Lynn R · Fort Lauderdale, FLS/N 7567

Back to AD 87-20-03 R2