Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N4262HNorthern Iowa Anesthesia Services P L C · Ames, IAS/N 24-0688 N4264QAlbrecht Paul J · Mine Hill, NJBuilt 1971 · S/N 17260164 N4265QParrish Aviation Flight Academy LLC · Southlake, TXS/N 17260165 N4266QMaxwell James B · Lewiston, IDBuilt 1971 · S/N 17260166 N4267ERmd Enterprises LLC · Rockwall, TXBuilt 1978 · S/N 38-78A0515 N4267HGmt Enterprises LLC · Stephenville, TXFirst renewal noticeBuilt 1978 · S/N 24-0690 N4267QDhf LLC · Valentine, NEBuilt 1971 · S/N 17260167 N4269HSiniakin Michael K · East Brunswick, NJBuilt 1978 · S/N 24-0692 N426DLHawk30 Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG0827 N426HLGiurtino Joel F · Spring Hill, FLBuilt 1977 · S/N 17269050 N426MCMagic Carpet LLC · Wilmington, DEBuilt 1971 · S/N 17260022 N426SKBergstrom Aircraft Inc · Pasco, WABuilt 1979 · S/N 17273720 N4270QReeves James C · Locust Grove, GABuilt 1971 · S/N 17260170 N4273HWooten William E Jr · Taft, TNBuilt 1979 · S/N 24-0772 N4273QSimmons Robert J · Justin, TXBuilt 1971 · S/N 17260173 N4274QLjn Aircraft LLC · Jamestown, NYBuilt 1971 · S/N 17260174 N4275EAllison Larry J · Villa Rica, GAS/N 38-78A0521 N4276QOjdrovich George · Steamboat Springs, COBuilt 1971 · S/N 17260176 N4277QRawlins William David Sr · Martinez, GABuilt 1971 · S/N 17260177 N4278LIron Compass Aviation LLC · Gallatin, TNBuilt 1978 · S/N 15281218 N427ACNoyes Shawn R · Hudson Oaks, TXBuilt 2000 · S/N 1299-2000 N427BPBest Kenneth M · Sullivan, ILBuilt 1973 · S/N 177RG0434 N427JGLigon Scott A · Florence, ALBuilt 1973 · S/N 17261688 N427SFN427sf LLC · Lakeview, NCBuilt 1966 · S/N 3410 N4281QMcdonald Air Services LLC · Saint Johns, MIBuilt 1971 · S/N 17260181 N4282QShirley Walter Allen · Bullhead City, AZBuilt 1971 · S/N 17260182 N4283SHayes Timothy · Gray, MEBuilt 1974 · S/N 17263748 N4284PEmpire Aviators LLC · Long Island City, NYS/N 17264088 N4285QShielded Holdings LLC · Katy, TXBuilt 1971 · S/N 17260185 N4287QMonmouth Area Flying Club · Lakewood, NJBuilt 1971 · S/N 17260187 N4288QN4288q LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260188 N4289HGiguere Michael R · Danielson, CTBuilt 1978 · S/N 24-0696 N428ACMckinley Nathan C · New Braunfels, TXBuilt 2000 · S/N 1288-2000 N428HCNott Terry · Overland Park, KSBuilt 1979 · S/N 15283916 N428RGGandolfo Air LLC · Watertown, CTBuilt 1973 · S/N 17262092 N4290EAnderson Todd R · Bremerton, WABuilt 1978 · S/N 38-78A0532 N4292QSky Walker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17260192 N4293HHelleberg John R · Centreville, VABuilt 1978 · S/N 24-0697 N4293QKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1971 · S/N 17260193 N4294QOptimized Aviation Services LLC · Huntington Station, NYS/N 17260194 N4296QAirjohn LLC · Cheyenne, WYBuilt 1971 · S/N 17260196 N4297HAirswiss Inc · Wilmington, DEBuilt 1978 · S/N 24-0699 N4297QCritchfield David P · Paradise, CAS/N 17260197 N4298EParish Matthew G · Drummonds, TNBuilt 1978 · S/N 38-78A0535 N4298QDarrach Todd I · Rhome, TXS/N 17260198 N429ACRegistration Pending · Morris, ILRegistration pendingBuilt 1999 · S/N 429-99 N429BASchmidt John M · Palm Coast, FLS/N 17702654 N42APMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1977 · S/N 17269941 N42CMMazor Chris · Belleville, MIS/N 17266374 N42CPHingst Arthur · Hermann, MOBuilt 1965 · S/N 587

Back to AD 80-25-07 R1