Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N1280TCertified Equipment Inspections LLC · Washington, PABuilt 1972 · S/N 28R-7235253 N1284WBethel Don G · Bossier City, LABuilt 1967 · S/N 28R-30304 N128GRJaques Stanley S · Cassville, MOBuilt 1968 · S/N 28R-30806 N128LBWareham Andrew John · Wasilla, AKBuilt 1966 · S/N 30-1132 N1293TN1293t LLC · Wilmington, DES/N 34-7250283 N129AVCochran Jeffrey · Lincoln, NEBuilt 1980 · S/N 34-8070309 N129EWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N 28R7335265 N129SAUnlimited Vertical LLC · Milton Freewater, ORS/N 28R-7737053 N12FSLawley Frederick E · Bozeman, MTBuilt 1966 · S/N 30-1226 N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284 N12RDFlying Colors Airparts Inc · Leesburg, FLBuilt 1958 · S/N 24-368 N130DGDixie Aviation LLC · Pelham, ALBuilt 1972 · S/N 28R-7235127 N130MMMighty Mike LLC · Maysville, KYBuilt 1964 · S/N 30-550 N130TLynch Machining LLC · North Vernon, INBuilt 2003 · S/N 2844104 N1316ASky West Aviation Inc Trustee · Albuquerque, NMS/N 347770258 N1318HEvern Properties LLC · Kalispell, MTS/N 28R-7703022 N1321HKronick Brad S · Grand Prairie, TXS/N 32R-7780152 N132CTausch Roger M · Saint Charles, MIBuilt 1963 · S/N 30-62 N132CTHanger Six LLC · Birmingham, ALBuilt 1978 · S/N 34-7870179 N1333HN1333h LLC · Brooklyn, NYS/N 32R-7780154 N1334HPreskar Michael H · Ione, CABuilt 1977 · S/N 34-7770121 N1334TCrt Aviation LLC · Clarkston, MIBuilt 1972 · S/N 28R-7235263 N133CBBrown Milton S III · Raleigh, NCBuilt 1974 · S/N 28R-7435318 N1341TShuman Cecil R Trustee · Chugiak, AKBuilt 1972 · S/N 28R-7235264 N1342TCrewdawg Aviation LLC · Concord, NCBuilt 1972 · S/N 28R-7235265 N1347HKapp Dean R · New Berlin, WIS/N 28R-7703023 N1349TMjl Flyers LLC · Somerset, PABuilt 1972 · S/N 28R-7235266 N134ACSkyline Solutions Inc · Deland, FLBuilt 1972 · S/N 34-7350014 N134JSSparling Albert E · Hubbard Lake, MIBuilt 1968 · S/N 28R-30517 N1354TRiverside Flight Academy Inc · Riverside, CABuilt 1972 · S/N 28R-7235268 N135DGSg Solutions LLC · Reno, NVBuilt 1977 · S/N 28R-7803122 N1360TDibrino Ruth G · Hillsboro, ORBuilt 1972 · S/N 28R-7235269 N1367TN1367t LLC · Mount Dora, FLBuilt 1972 · S/N 28R-7235271 N1369TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250301 N136YJanoski David M · Fort Worth, TXBuilt 1960 · S/N 24-1991 N137CCMore Right Rudder LLC · Sioux City, IABuilt 1977 · S/N 28R-7737065 N1380TN1380t LLC · Wilmington, DEBuilt 1972 · S/N 34-7250302 N1385TRayfield Charles · Downingtown, PABuilt 1972 · S/N 28R-7235274 N1386TGeorgia Aviation Authority · Eastman, GABuilt 2003 · S/N 2844101 N1389HDouble Dd Arrow Aviation LLC · Graham, TXS/N 28R-7703024 N1390TAccessible Aviation Inc · Tupelo, MSBuilt 1972 · S/N 34-7250274 N1395TLegacy Aerospace Industries LLC · Miami, FLS/N 28R-7235277 N1397HIngold Terry L · Albemarle, NCS/N 34-7770124 N1399TLauff Samuel Jr · Ocala, FLBuilt 1972 · S/N 28R-7235278 N139CASquires Gregory K · Cedar Park, TXBuilt 1966 · S/N 24-4570 N139DMMurillo Raymond A · Pico Rivera, CABuilt 1969 · S/N 28R-35262 N139YPSmuzzle Air LLC · Longboat, FLBuilt 1977 · S/N 28R-7703364 N13AGWeather Modification LLC · Fargo, NDBuilt 1977 · S/N 34-7770115 N13GPWeidner Kevin G · Bunker Hill, ILBuilt 1967 · S/N 30-1535 N13LMTupelo Limited Lc · Lake Charles, LAS/N 34-7870075

Back to AD 97-01-01 R1