Registered aircraft · 6,238

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-18-06-R1') 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-18-06-R1') 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-18-06-R1')
    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-18-06-R1')
  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-18-06-R1')
  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-18-06-R1')
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.

N3777SStuart Guy · Owosso, MIBuilt 2000 · S/N E-3351 N377DShawn Wyatt Enterprises Inc · Huntsville, TXBuilt 1983 · S/N E-2087 N377KCEagle Flying Club LLC · Enid, OKBuilt 1977 · S/N E-1032 N377TMuffler Ronald J Trustee · Salt Lake City, UTS/N E3416 N378GPE Graham Investments LLC · Sanford, FLBuilt 1975 · S/N CE-602 N3799MWaldron Ronald · Strongsville, OHBuilt 1980 · S/N E-1774 N379JRDanny Skaggs Co Inc · San Antonio, TXBuilt 1984 · S/N TJ-447 N379LV379lv LLC · Broomfield, COBuilt 1982 · S/N TJ423 N37BRC&D Pharmaceuticals Berry Inc · Berry, ALBuilt 1981 · S/N E-1860 N37BSMatthew Davis · Asheville, NCBuilt 1974 · S/N E-548 N37CHDehaan Aviation LLC · Bethel, AKBuilt 1979 · S/N E-1460 N37MCTvb Aviation LLC · Mcallen, TXBuilt 1988 · S/N CE-1258 N37MKSkyhoundmedia Inc · Royal Oak, MIBuilt 1970 · S/N D-9168 N37RAGustafson John A Trustee · Boulder City, NVBuilt 2001 · S/N E-3422 N37RCCorrao Robert F Jr · Scottsdale, AZBuilt 1995 · S/N E-2986 N3801BSunshine N756fc LLC · Stamford, TXBuilt 1980 · S/N CE-931 N3801CDanuser Aviation LLC · Fulton, MOBuilt 1980 · S/N EA-167 N38020Pardue Hines Aviation LLC · Lincolnton, NCBuilt 1980 · S/N TH-1208 N3802JDental Surgical Center Of Medina Inc · Medina, OHS/N E-1781 N3802NDiehl Donald L · Garden City, KSBuilt 1980 · S/N EA-170 N3802PCassill Aircraft Leasing Inc · Cedar Rapids, IABuilt 1980 · S/N E-1782 N3802XFerri Thomas K · Hillsborough, NCBuilt 1980 · S/N CE-932 N3803MRegistered aircraftBuilt 1980 · S/N D-10357 N38040Mosier Daniel J · Tucson, AZBuilt 1980 · S/N EA-175 N38049Moore Aviation Services LLC · San Antonio, TXBuilt 1980 · S/N EA-178 N3804ABig Love LLC · Tifton, GABuilt 1983 · S/N TH-1381 N3804MGlenmont Air LLC · Strasburg, VABuilt 1981 · S/N TJ-328 N38065Boyd David · Havasu, AZBuilt 1980 · S/N D-10361 N3806LPeterson Ross D · Hutchinson, MNBuilt 1980 · S/N E-1793 N3806XTessec LLC · Cincinnati, OHBuilt 1980 · S/N TH-1215 N38071Carter Donald P Trustee · Merced, CABuilt 1980 · S/N CE-935 N3807EDonaghe Larry Chance · Rockwall, TXBuilt 1981 · S/N E-1809 N3807TAmbrose Construction Ltd · Corpus Christi, TXBuilt 1980 · S/N TJ-332 N3807XAlpha Bravo Lima LLC · Covington, TNBuilt 1980 · S/N EA-179 N38081Heitmeier Cody F · New Orleans, LAS/N E-1798 N38082Pope Bill F · Prescott Valley, AZBuilt 1980 · S/N EA-183 N38089Dabbs Randal L · Lenoir City, TNBuilt 1980 · S/N TH-1218 N3808QJordan Klein DBA · Summerfield, FLS/N CE-936 N3809KGeneral Aviation Services LLC · Franklin, TNBuilt 1981 · S/N TH-1219 N380PCRhomberg Bernard B · Elm Grove, WIBuilt 1978 · S/N E-1384 N3810CBlake Thomas C · Vero Beach, FLBuilt 1981 · S/N TJ-335 N3810ZFalcon Ridge Industries Inc · Milleville, NJBuilt 1980 · S/N E-1802 N3813QBemowski Paul · Madison, WIBuilt 1981 · S/N EA-187 N3815KShoemaker James W · Hilltop Lakes, TXBuilt 1980 · S/N CE-939 N3815PNorth Louisiana Aviation LLC · Mer Rouge, LABuilt 1981 · S/N E-1850 N38168Jjj&S Aviation Corp · Brooklyn, NYBuilt 1981 · S/N E-1808 N3816SKey Field Flyers LLC · Toomsuba, MSBuilt 1981 · S/N E-1806 N38175Fhg Springbrook Corp · Wilmington, DEBuilt 1981 · S/N CE-940 N3817MGulf Skies LLC · Kalispell, MTBuilt 1981 · S/N EA-191 N381CRSiemsen Randall R · Clovis, CABuilt 1976 · S/N E-875

Back to AD 87-18-06 R1