Skip to content

Registered aircraft · 22,416

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N94PMKingdom Planes LLC · Decatur, TXBuilt 1982 · S/N 28R-8218018 N94RRMaxwell Theresia · Charlotte, NCBuilt 1979 · S/N 28R-7918144 N94TFWildblue LLC · Edgerton, MOBuilt 1994 · S/N 3213074 N94WAVidal Aviation LLC · Gaithersburg, MDS/N 2843118 N95008Ottaway Brent E · Derby, KSBuilt 1969 · S/N 28-25775 N9500JMidwest Air Freight LLC · Sioux City, IABuilt 1966 · S/N 28-3620 N9500WRachel Calvin · Kimberly, ALS/N 28-22921 N9501JKnutson Donald W · Litchfield, MNBuilt 1966 · S/N 28-3621 N9502WHellevang Ryan K · Duvall, WAS/N 28-22924 N9503WLoya Armando · Whittier, CAS/N 28-22925 N95044Mach Point Two Aviation LLC · Conroe, TXBuilt 1969 · S/N 28-25783 N9504WS&J Aviation LLC · Burlington, WABuilt 1967 · S/N 28-22926 N95053Jamesweathers Robi J · Blaine, MNBuilt 1969 · S/N 28-25788 N9505JConnors Paul J II · Murrieta, CABuilt 1966 · S/N 28-3626 N95063Dugan Jason · Wellington, TXBuilt 1969 · S/N 28-25794 N95069Tower Aviation Of Reading Inc · Reading, PABuilt 1969 · S/N 28-25797 N9506CValdez Edgar Librado · Mcallen, TXS/N 32R-7985026 N9506JEspinal Branhder · Union, NJBuilt 1966 · S/N 28-3627 N95071Lund Jonathan J · Glencoe, MNBuilt 1969 · S/N 28-25798 N95080Johnson Patrick W · Toney, ALBuilt 1969 · S/N 28-25800 N95084Lyons Nathaniel R · Fort Scott, KSBuilt 1969 · S/N 28-25801 N95089Moll Michael J II · Mechanicville, NYBuilt 1969 · S/N 28-25804 N9508JGandas Aero Inc · Eagan, MNS/N 28-3629 N95091Jts Aircraft LLC · Rock Hill, SCBuilt 1969 · S/N 28-25805 N9509JStevens Sheldon D · Clark, SDBuilt 1966 · S/N 28-3630 N950DSSchmitt Douglas F · Bloomsbury, NJBuilt 1978 · S/N 28R-7837167 N950TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881950 N95105Airbud Aviation LLC · Morristown, NJBuilt 1969 · S/N 28-25806 N95111Tiny Tin Aviation LLC · Groveland, FLBuilt 1969 · S/N 28-25808 N9511JGomez Alexandro · Riverside, CABuilt 1966 · S/N 28-3633 N9511KMoore Matt R · Nashville, TNS/N 28-7625182 N95121Preston Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28-25814 N9512CDe Aviation Inc · La Porte, TXBuilt 1978 · S/N 28-7816487 N9512JArapahoe Flight Club LLC · Colorado Springs, COBuilt 1966 · S/N 28-3634 N95133Rd Aire LLC · Opelika, ALBuilt 1969 · S/N 28-25818 N9513CAgri Business Aviation Inc · Sparta, ILBuilt 1978 · S/N 28-7890418 N9513JGlorioso Richard · Plant City, FLBuilt 1966 · S/N 28-3635 N95147Ramirez Ricardo A · San Antonio, TXBuilt 1969 · S/N 28-25822 N9514JDu Bois Aviation Inc · Chino, CABuilt 1966 · S/N 28-3637 N95151Gonzalez-Pinto Carmelo · San Antonio, TXBuilt 1969 · S/N 28-25823 N95154Cen Inc · Sheridan, WYS/N 28-25825 N95157Smutek Brian D · Mio, MIBuilt 1969 · S/N 28-25828 N9515JBowman Alex T · Virginia Beach, VABuilt 1966 · S/N 28-3638 N9515KBoyd Matthew · Hudsonville, MIBuilt 1976 · S/N 28-7615209 N95160Registration Pending · Lakewood Ranch, FLRegistration pendingBuilt 1969 · S/N 28-25829 N9516KSmith Dalton L Trustee · Smyrna, DEBuilt 1976 · S/N 28-7615210 N95173First Flight Corporation · San Diego, CABuilt 1969 · S/N 28-25832 N9517JBanks Brian H · Zebulon, GABuilt 1966 · S/N 28-3640 N95181Stahl Jason R · Etters, PABuilt 1969 · S/N 28-25835 N9518WMarshall Christopher · Oshkosh, WIBuilt 1967 · S/N 28-22944

Back to AD 87-08-08 R3