Skip to content

Registered aircraft · 3,466

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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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:2002-07-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
  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:2002-07-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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.

N1658URenfro Michael W · Bethel, AKBuilt 1974 · S/N 20700258 N1668UUngalik Syndicate LLC · Unalakleet, AKBuilt 1975 · S/N 20700268 N166ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1986 · S/N U20606923 N1675XNo Runways LLC · Iraan, TXBuilt 1975 · S/N 21060710 N1676UDigicam Co · Henderson, NVBuilt 1982 · S/N 21064724 N1676XSkydancer Le LLC · Wilmington, DEBuilt 1975 · S/N 21060711 N1678XFly Guys LLC · Arcata, CABuilt 1975 · S/N 21060713 N1679XBouchereau Raymond Jr · San Dimas, CABuilt 1975 · S/N 21060714 N1681UMeise Bill · Spring Green, WIBuilt 1982 · S/N 21064725 N1687XMorton Douglas E · Cody, WYBuilt 1975 · S/N 21060722 N168SABruchid Snodgrass LLC · Reno, NVBuilt 1981 · S/N U20606073 N168SDCometenterprises.Net LLC · Kalispell, MTBuilt 1979 · S/N P21000460 N1696XCenturion LLC · New Bern, NCBuilt 1975 · S/N 21060731 N1698XCmo Blue Sky LLC · Tomball, TXS/N 21060733 N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169 N169PGHarty Joshua · Strasburg, COS/N T210-0423 N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101 N16CJRoyale Air Service Inc · Fort Myers, FLS/N U20602501 N16GBWester Lawrence Cale · Star, IDBuilt 1973 · S/N U20602075 N16GPDeckload Aviation LLC · Kodiak, AKS/N U20604467 N16ZAVisser Johannes Christoffel · Reno, NVBuilt 1980 · S/N 21063807 N1704UKuspuk School District · Aniak, AKBuilt 1975 · S/N 20700304 N1716XBell Brian · Oakland, CABuilt 1975 · S/N 21060738 N1717XSay Plastics Inc · Jacksonville, TXBuilt 1967 · S/N T2100267 N1717YSeventeen Yankee LLC · Fort Lauderdale, FLBuilt 1979 · S/N U20605030 N171BCR Wesley Aviation LLC · Chandler, AZBuilt 1981 · S/N 64251 N171KSVida Vibrante LLC · San Juan, PRBuilt 1979 · S/N 21063167 N171RMMckinney Mark · Meadowview, VABuilt 1972 · S/N U20601938 N171RSSeneque USA Inc · West Palm Beach, FLBuilt 1980 · S/N U20605558 N171TMG&L Aviation Services LLC · Las Vegas, NVBuilt 1980 · S/N 21063894 N1720XKregel Brian D · Garnavillo, IABuilt 1975 · S/N 21060742 N1723BBoyko George · Tarpon Springs, FLBuilt 1979 · S/N 206-05190 N1733RNorthstar Holdings LLC · Anchorage, AKBuilt 1973 · S/N U20602068 N1734UWing Nutz LLC · Pasadena, CABuilt 1982 · S/N 21064735 N1734XRight Wing Left Wing Flyers LLC · Cleveland, GABuilt 1975 · S/N 21060755 N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960 N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763 N1744XDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21060765 N1747BDgpiper · Sheridan, WYBuilt 1980 · S/N 20700666 N1748RNorthstar Holdings LLC · Anchorage, AKBuilt 1980 · S/N U20605438 N1748UIliamna Air Taxi Inc · Iliamna, AKBuilt 1976 · S/N 20700348 N1749UFreshwater Adventures Inc · Dillingham, AKBuilt 1976 · S/N 20700349 N174SFTaylor Thomas R · Lenoir, NCBuilt 1978 · S/N P21000174 N1750URenfro Michael W · Bethel, AKBuilt 1976 · S/N 20700350 N1754USutton Aircraft Salvage LLC · Palmer, AKBuilt 1976 · S/N 20700354 N1754XWest Alabama Lime Co Inc · Livingston, ALBuilt 1975 · S/N 21060775 N1756URude Daniel R · Leesbug, VABuilt 1982 · S/N 21064739 N1758UBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 20700358 N1763XRobins Nest Aviation LLC · Harrison, OHBuilt 1975 · S/N 21060784 N1764XLeschber Larry · Hutto, TXBuilt 1975 · S/N 21060785

Back to AD 2002-07-01