Skip to content

Registered aircraft · 22,413

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.

N3738WNewton Machine Co Inc · Charlotte, NCBuilt 1966 · S/N 32-652 N3739WPacific Gold Aviation Association · Roseville, CABuilt 1966 · S/N 32-653 N373BSPenn Mitchell · Poplar Bluff, MOBuilt 1969 · S/N 28-26555 N373CACoco Aircraft Inc · Merritt Island, FLBuilt 1988 · S/N 2841014 N373CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2844174 N373HPHandal Fred · Ladera Ranch, CABuilt 2001 · S/N 3257245 N373MKNorth Star Aviation · Mankato, MNBuilt 2025 · S/N 2881986 N373PFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 28 R 801 8040 N3740TBibbey Mark A · Chandler, AZBuilt 1967 · S/N 28R-30049 N3741TIowair Inc DBA · Atkins, IABuilt 1968 · S/N 28R-30957 N3742WRibas Daniel · Atascadero, CABuilt 1966 · S/N 32-656 N3743QTonneson Rollin J · Souris, NDBuilt 1977 · S/N 28-7790464 N3744QIndian River Flying Club Inc · Rockledge, FLS/N 28-7790465 N3744TAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30054 N3745QBeer Aviation LLC · Santa Rosa Beach, FLS/N 28R-7737058 N3745THill James C · Grand Saline, TXS/N 28R-30055 N3746MParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7816372 N3746THeinemann Daniel J · Lynchburg, TNBuilt 1968 · S/N 28R-30958 N3746WN3746w Corp · Wilmington, DEBuilt 1966 · S/N 32-660 N3747KBelcher Randall Mcarthur II · Lake Havasu City, AZBuilt 1967 · S/N 28-23718 N3748TBaki Christian · Ocoee, FLBuilt 1967 · S/N 28R-30058 N37491Tuskegee Airmen National Historical Museum Inc · Detroit, MIS/N 32-7340177 N374BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881774 N374CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2844175 N374FTNortheast Planes Aviation Inc · Hillrose, COBuilt 1982 · S/N 28-8216213 N374GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881117 N374HPParrish Blake · Seminole, TXBuilt 2002 · S/N 3257274 N374MKNorth Star Aviation · Mankato, MNBuilt 2025 · S/N 2881987 N3750KDalton Bart · Owasso, OKBuilt 1967 · S/N 28-23719 N3750TNevius Matthew W · Freeport, FLBuilt 1967 · S/N 28R-30059 N3750WNichols John L · Parksville, NYS/N 32-664 N3751WEthridge Lee C · Mount Pleasant, TXBuilt 1966 · S/N 32-665 N3752TSharp Jim C · Stephenville, TXBuilt 1967 · S/N 28R-30061 N3753MEighties Aviation LLC · Wilmington, DES/N 28-7890329 N3753THalcyone Holding LLC · Santa Teresa, NMBuilt 1967 · S/N 28R-30062 N3754TWells Brian T · Gonzales, TXS/N 28R-30063 N3754WHam Aviation LLC · Maysville, KYBuilt 1966 · S/N 32-669 N3755MEshleman James E · Yucaipa, CABuilt 1978 · S/N 28-7890330 N3755QNarwhal Airlines LLC · Odessa, TXS/N 28R-7703116 N3755TAmr Pilot Services LLC · Jersey City, NJS/N 28R-30064 N3755WMs Air LLC · Hickory, NCBuilt 1966 · S/N 32-670 N3756REllington Christopher T · Owenton, KYBuilt 1970 · S/N 28-5814 N3756WAranda Jarrod A · Vancouver, WABuilt 1966 · S/N 32-671 N3757KSkylux Aviation LLC · Coppell, TXBuilt 1967 · S/N 28-23721 N3757TA&P Paul LLC · Columbia, CTS/N 28R-30066 N3757WSowden Nathan S · Annapolis, MDBuilt 1966 · S/N 32-672 N3759TVelez Jose C · Port Orange, FLBuilt 1967 · S/N 28R-30068 N375BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881775 N375CThornhill Jared Wayne · Shallowater, TXBuilt 2003 · S/N 3255002 N3760TArizaga Diana M · Mamaroneck, NYBuilt 1967 · S/N 28R-30069

Back to AD 87-08-08 R3