Skip to content

Registered aircraft · 26,231

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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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.

N17106Tate Daron D Trustee · Pasco, WABuilt 1972 · S/N 15073627 N1710FValley Aviators Inc · Williston, NDBuilt 1966 · S/N 17255105 N1710VWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1947 · S/N 13895 N1711Burgess Mark W · Greene, MES/N 1 N1711KNormandy Flyers Limited Inc · Middletown, DEBuilt 1946 · S/N 4438 N1711QSwing Brian S · Vero Beach, FLBuilt 1982 · S/N 2229 N1712DRichter Ty G · Buffalo, SDBuilt 1951 · S/N 20155 N1712KDethardt James J · Little Chute, WIBuilt 1947 · S/N 4439 N1712NPinger Kevin R · Palo Alto, CABuilt 1946 · S/N 11956 N17134Trappe Enterprises LLC · Street, MDBuilt 1972 · S/N 15073633 N17136Ireland Brian T · Newberg, ORS/N 15073635 N1713EMurray Donald L · Two Harbors, MNBuilt 1946 · S/N 7AC-5278 N1713KRegistration Pending · Columbia, MORegistration pendingS/N 4440 N1713QMaier Brandon · Eagle Grove, IABuilt 1971 · S/N 15073013 N17141Dawson Aircraft Inc · Clinton, ARBuilt 1972 · S/N 15073638 N17143Misner Gear K · Phoenix, AZBuilt 1972 · S/N 15073640 N1714DBellenir Michael A · Mastic Beach, NYBuilt 1951 · S/N 20157 N1714QRoth Mark E · Stevensville, MTBuilt 1971 · S/N 15073014 N1715DPulley Richard A · Chugiak, AKBuilt 1951 · S/N 20158 N1715FBradley Max T II · West Plains, MOBuilt 1966 · S/N 17255110 N1715KHurlburt Ronald V DBA · Durand, WIBuilt 1946 · S/N 4442 N1715NGerzevitz Robert M · San Diego, CABuilt 1948 · S/N 11959 N17170Cannon Christopher H · Moorpark, CABuilt 1972 · S/N 15073644 N17174Davison Mark L · Vacaville, CAS/N 15073648 N17176Johns Thomas D · West Hills, CABuilt 1972 · S/N 15073649 N1717KJ Smith Ranch Inc · Condon, ORBuilt 1949 · S/N 4444 N1717NDagenhart Kagan · Midland, TXBuilt 1946 · S/N 11961 N17181Hays Jerry W · Heath, TXBuilt 1972 · S/N 15073652 N1718DSwe3 LLC · Seattle, WABuilt 1951 · S/N 20161 N1718FSavage David E · American Falls, IDS/N 17255113 N1718QRegistered aircraftS/N 15073018 N1719DHurd Matthew · Recluse, WYBuilt 1952 · S/N 20342 N1719FMoran Aviation LLC · Rose Bud, ARS/N 17255114 N1719MJohnson David H · Jasper, GAS/N 7BCM-73 N1719QMartinz Mike · Big Timber, MTBuilt 1971 · S/N 15073019 N171LCSilver Ace Aerosports Inc · Toccoa, GAS/N AL-1145 N171RJSawyer Eric O · Redding, CABuilt 1966 · S/N 15063038 N17200Horton Andrea L · Auburn, CABuilt 1972 · S/N 15073659 N17203Ds Flight Services LLC · Battle Groun, WAS/N 15073662 N1720DDriver Jonathan S · Oakland Park, FLBuilt 1951 · S/N 20163 N1720VEdmonds Sherry B · Georges Mills, NHBuilt 1947 · S/N 13905 N17210Babler Paul W · Blaine, MNBuilt 1972 · S/N 15073666 N17218Papich William · Boston, NYBuilt 1972 · S/N 15073671 N1721FCenterline Flying Club Inc · Williamstown, NJBuilt 1966 · S/N 17255116 N1721KLetkeman John K · Seminole, TXS/N 4448 N1721VCollins Gary C · Asheboro, NCBuilt 1947 · S/N 13906 N17221Gray Jimmie E · Punta Gorda, FLS/N 15073673 N1722FLeone William T II · Canfield, OHBuilt 1966 · S/N 17255117 N1722KKechner Scott · New Hudson, MIBuilt 1946 · S/N 4449 N1722SShoemake Gregory Allen · Palmer, AKS/N 28656

Back to AD 94-05-05 R1