Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N1474ESuffolk County Police Pilots Assoc · Bayport, NYBuilt 1978 · S/N 17271015 N1474FJlb Aviation Services LLC · Woodbine, NJBuilt 1979 · S/N 17273008 N1474UHentges Jerry J · Morris, MNBuilt 1976 · S/N 17267141 N1475VGlobal Flight Training Solutions Inc · Immokalee, FLS/N 17263610 N1475YAbe Lincoln Flyers Inc · Lincoln, ILBuilt 1962 · S/N 17249175 N1476UTampa Bay Aviation Inc · Clearwater, FLBuilt 1976 · S/N 17267143 N1476YHamilton Gene A · Saegertown, PABuilt 1962 · S/N 17249176 N1477FMavity Reagan Chase · Clayton, GABuilt 1966 · S/N 17254972 N1477VSatermo Lee John · New Town, NDBuilt 1974 · S/N 17263612 N1478FElliott Gabrial Adam · Hollywood, ALBuilt 1966 · S/N 17254973 N1478YCunningham Richard E · Lafayette, CABuilt 1962 · S/N 17249178 N1479EAero Capital Lending LLC · Miami, FLBuilt 1978 · S/N 17271016 N1479USperoni Pablo · Vieques, PRBuilt 1976 · S/N 17267146 N147HAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10219 N147JFour Seven Jays Flying Club Inc · Rapids City, ILBuilt 1973 · S/N 17262545 N1480USchaad Michael · Yorba Linda, CABuilt 1976 · S/N 17267147 N14814Florida Flight Training Center Inc · Venice, FLBuilt 2007 · S/N 172S10451 N1481VTalbert Barbara E · Wesley Chapel, FLBuilt 1974 · S/N 17263615 N1481YPoole Timothy W · Lyons, GABuilt 1962 · S/N 17249181 N14829Ssea Properties LLC · Double Oak, TXBuilt 2007 · S/N 172S10585 N1482VGriffin Samuel · Doniphan, MOBuilt 1974 · S/N 17263616 N1482YSamuelian Jenna A · Tehachapi, CABuilt 1962 · S/N 17249182 N1483UJohnson William Scott · New Market, TNBuilt 1976 · S/N 17267150 N1483VRankin Kevin · Maryville, MOS/N 17250241 N1484BMann Aviation Inc · Long Beach, CABuilt 2007 · S/N 172S10452 N1484UCrescent City Aviation Club LLC · New Orleans, LABuilt 1976 · S/N 17267151 N1484YHarrison Dennis N · New London, MOS/N 17249184 N1485UClass A Aviators Inc · Parsons, KSBuilt 1976 · S/N 17267152 N1486UMoss Motor Company Inc · South Pittsburg, TNBuilt 1976 · S/N 17267153 N1486YPost Greg · Fort Scott, KSBuilt 1962 · S/N 17249186 N1487UNew Richard A · Deming, WABuilt 1976 · S/N 17267154 N1487VFirst Flight Corporation · San Diego, CABuilt 1974 · S/N 17263621 N1488CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12896 N1488UShine Donald J · Waterford, WIBuilt 1976 · S/N 17267155 N1488VPerks Brian G · Otis Orchards, WAS/N 17263622 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019 N1489FHoover Andrew V · Jenison, MIBuilt 1966 · S/N 17254984 N1489UAustin Aeroflight Inc · Austin, MNBuilt 1976 · S/N 17267156 N1490EFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1978 · S/N 17271020 N1491UGardner Christopher · Farmers Branch, TXBuilt 1976 · S/N 17267158 N1491YBullard Thomas Eugene Trustee · Midlothian, TXBuilt 1962 · S/N 17249191 N1493ESherman Aviation LLC · Fairfield, NJBuilt 1978 · S/N 17271022 N1493FAdventist World · Wilson, NCBuilt 1966 · S/N 17254988 N1493VMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263623 N1494FThompson Kevin L · Jefferson, TXBuilt 1966 · S/N 17254989 N1494VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263624 N1495UFairflight LLC · San Diego, CABuilt 1976 · S/N 17267162 N1496FSmith James F · Red Springs, NCBuilt 1966 · S/N 17254991 N1496YHoward Paul D · Gordon, TXS/N 17249196 N1497FBlunk Rodney · Bettendorf, IABuilt 1966 · S/N 17254992

Back to AD 90-06-03 R1