Registered aircraft · 72,010

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

N507MAAviation Consultants US Inc · Beaver Falls, PABuilt 2004 · S/N 3255014 N507RGMccurdy Paul R · North Falmouth, MABuilt 1995 · S/N 2507 N507RHJones Douglas H · Prather, CABuilt 1993 · S/N 20200 N507SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881421 N507THLeyva Maria · Edgewater, FLBuilt 1971 · S/N 34-7250037 N5080WMatzke Kevin T · Gilbert, AZBuilt 1961 · S/N 28-89 N5080XOber John A · Candor, NYBuilt 1968 · S/N 143 N5081SDream Factory Aviation Inc · Henderson, NVBuilt 1971 · S/N 28R-7135081 N5081UKiloecho Aeronautics LLC · Tucson, AZBuilt 1971 · S/N 17259673 N5081VWalker Gregory S · Gypsum, COBuilt 1977 · S/N VAC-70-77 N5081YDoumis Joy S · Marathon, FLBuilt 1962 · S/N 27-2099 N50822Nyhus Sharon L · Harvey, NDBuilt 1980 · S/N 17274221 N50826Bristol Bay Capital LLC · Watkins, COS/N 17274222 N5082GJala Tech Services LLC · Social Circle, GABuilt 1979 · S/N 17273531 N5082PShaw Jeryl V · Arcata, CABuilt 1958 · S/N 24-88 N5082RWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263320 N5082VMorton John W · El Segundo, CABuilt 1977 · S/N VAC-71-77 N5082WAmeeti Robert Keith Trustee · Newport Beach, CABuilt 2001 · S/N 172S8970 N5082YTanner Greg · Bend, ORBuilt 1962 · S/N 27-2100 N50838Ansee LLC · Seattle, WABuilt 1980 · S/N 17274224 N5083CTsf Inc · Bristol, WIBuilt 1980 · S/N R18201555 N5083KLoewen Wielhelm N · Presidio, TXBuilt 1980 · S/N 17273956 N5083SRiser Air LLC · Stillwater, MNBuilt 1971 · S/N 28R-7135082 N5083VBarth Charles L · Pekin, ILBuilt 1977 · S/N VAC72-77 N5083XFlytails LLC · Pace, MSFirst renewal noticeBuilt 1968 · S/N 155 N5084MFabrizio Timothy · Oswego, ILBuilt 1978 · S/N MC-571 N5084RBenham Eric T · Las Vegas, NVBuilt 1974 · S/N 17263322 N5084WShouse Robert G · Owasso, OKBuilt 1961 · S/N 28-93 N50854Fulton Lanny G · Spartanburg, SCBuilt 1968 · S/N 15069600 N5085KMartin Bach Aviation LLC · Cornelius, NCBuilt 1980 · S/N 17273957 N5085SHall Thomas K · Beaufort, NCBuilt 1971 · S/N 28R-7135085 N5085VStumpf Douglas D · Aledo, TXBuilt 1977 · S/N VAC74-77 N5085WMartin Marlin Ray Jr · Mabank, TXBuilt 1961 · S/N 28-94 N5085XAzzalin Giorgio · Jacksonville, FLS/N 158 N5086EPark David W · Placentia, CABuilt 1978 · S/N 17271703 N5086RSafety In Motion Flight Center Inc · Puyallup, WABuilt 1974 · S/N 17263324 N5086SAero Air Inc · Salt Lake City, UTBuilt 1971 · S/N 28R-7135086 N5086XJacono Bruce L · Ramona, CABuilt 1969 · S/N 159 N50873Bastien Peter M · Leesburg, VABuilt 1979 · S/N JR-1 N5087JSession Jason E · Higden, ARS/N 17273698 N5087KAir Capital Aviators Club · Wichita, KSBuilt 1980 · S/N 17273958 N5087SKartchner Stanley J · Tucson, AZBuilt 1980 · S/N R18201502 N5087WMcgough Craig N · Lancaster, TXBuilt 1961 · S/N 28-96 N5087XRichardson Ethan Mack · Mount Pleasant, SCBuilt 1969 · S/N 160 N5087YHansen Dewayne E · Fairbanks, AKBuilt 1962 · S/N 18-7894 N5088CMike Golf Holdings LLC · Pinellas Park, FLBuilt 1964 · S/N 30-497 N5088KG & M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 17273959 N5088MGeneral Aviation Partners LLC · Madison, ALBuilt 1967 · S/N 28-10928 N5088PKesser Gilbert M · Culpeper, VABuilt 1958 · S/N 24-94 N5088RGlacier Equipment LLC · Wasilla, AKBuilt 1974 · S/N 17263326

Back to AD 87-10-06 R1