Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N5108ZPfc Aviation Repair Inc · Wallingford, CTS/N 22-8748 N510ADDj Aztec LLC · Springfield, OHBuilt 1980 · S/N 27-8054044 N510DYoungs Water Conditioning Of Logansport LLC · Logansport, INS/N 27-7654024 N510GCSchramm Craig O · Fenton, MIBuilt 1964 · S/N 27-2681 N510UBoard Of Regents University Of Oklahoma · Norman, OKBuilt 2024 · S/N 4496588 N5111ZSlaughter Don Wayne · Farmville, NCBuilt 1961 · S/N 22-8751 N5113ZNielsen Jeffrey L · Harlan, IAS/N 22-8754 N5114PParris David T · Virginia Beach, VABuilt 1958 · S/N 24-126 N5115PSmith James Kelly · Newark, OHBuilt 1958 · S/N 24-127 N5115ZSager Charles J Jr · Wofford Heights, CABuilt 1961 · S/N 22-8756 N5117PMarsteller Michael A · Lugoff, SCBuilt 1959 · S/N 24-130 N5117ZWroe Daniel · Denton, MDBuilt 1961 · S/N 22-8758 N5118PMeng Marvin Allen Jr · Edwardsville, ILBuilt 1958 · S/N 24-131 N5118ZToner Phillip A · Devine, TXS/N 22-8759 N5121ZDahlberg Thomas K · Belvidere, ILBuilt 1961 · S/N 22-8762 N5122ZDunn Kohlten Davis · Rexburg, IDBuilt 1961 · S/N 22-8763 N5124ZCummings Christopher K · Chalfont, PABuilt 1961 · S/N 22-8765 N5125YTassopoulos Thomas · Flushing, NYBuilt 1962 · S/N 27-2158 N5126PElie Jonathan · Hopewell Junction, NYBuilt 1958 · S/N 24-139 N5126ZAshley Emory R · Panacea, FLBuilt 1961 · S/N 22-8767 N5128PSchafer David · Northport, ALBuilt 1958 · S/N 24-141 N5128ZMoore Merritt T II · Silver Creek, NYBuilt 1961 · S/N 22-8769 N5130PWhite Guy B · Waxahachie, TXBuilt 1958 · S/N 24-143 N5132PMccormick Geoffrey D · Goodyear, AZBuilt 1958 · S/N 24-145 N5136PDunn James F · Salem, INBuilt 1958 · S/N 24-150 N5137PFrancis Himanshu Raj · Blythewood, SCBuilt 1958 · S/N 24-151 N5137ZHill Glenn · Belle Mead, NJBuilt 1962 · S/N 22-9431 N5139ZKnarr Perry Lee · Lock Haven, PABuilt 1961 · S/N 22-8782 N5141PWest Texas Weather Modification Association · San Angelo, TXBuilt 1958 · S/N 24-156 N5142PBritz Store Equipment Inc · Buckman, MNBuilt 1958 · S/N 24-157 N5142ZFlorey Carl L · Eureka, MTBuilt 1961 · S/N 22-8791 N5143PUnusual Attitudes LLC · Bates City, MOBuilt 1958 · S/N 24-159 N5143ZHonkala Michael R · Wasilla, AKS/N 22-8789 N5144ZUlrich Kenneth B Jr · Kingwood, TXBuilt 1961 · S/N 22-8790 N5146ZBeloit Aviation LLC · Beloit, WIBuilt 1961 · S/N 22-8792 N5147PDunn Paul S Trustee · Santa Fe, NMBuilt 1958 · S/N 24-163 N5148PRegistered aircraftBuilt 1958 · S/N 24-164 N5149ZWeishaar Wallace · Livingston, TXBuilt 1961 · S/N 22-8797 N514CGFlight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 4496187 N5150PPeterson Richard A · Entiat, WABuilt 1958 · S/N 24-166 N5150ZBarilov Yekaterina · Santa Paula, CABuilt 1961 · S/N 22-8800 N5151PHone Ryan L · West Richland, WABuilt 1958 · S/N 24-167 N5151ZSanve Edwin K · Elk City, OKBuilt 1961 · S/N 22-8801 N5153PCjl Aviation LLC · Dover, DEBuilt 1958 · S/N 24-169 N5154PPerry Billy C · Newburgh, INBuilt 1958 · S/N 24-170 N5154ZSexton Gregory · Jordan, MNS/N 22-8804 N5155ZTowe Billy Joe Jr · Decatur, ALBuilt 1961 · S/N 22-8806 N5157YChristine Flight Inc · Denver, COBuilt 1962 · S/N 27-2196 N5159ZSiegel Scott A · Inez, KYS/N 22-8813 N515SRegistration Pending · Azle, TXRegistration pending, pending cancellationS/N 24-3609

Back to AD 85-02-05 R1