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.

N25212Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13396 N25213Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13399 N25218Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13402 N2521LExpert Construction Services LLC · Mclean, VAFirst renewal noticeBuilt 1966 · S/N 17255721 N2521YClanin James Robert · Vandalia, OHBuilt 1962 · S/N 17249821 N25220Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13405 N2522WHollenbeck William M · Montrose, COS/N 17250128 N2523YLawson Matt E · Gobles, MIBuilt 1962 · S/N 17249823 N2524LGraham Jacob W · Rose Hill, KSBuilt 1966 · S/N 17255724 N2524YPaul Danny W · Locust Grove, GABuilt 1962 · S/N 17249824 N2526YJahnke Ryan M · Grafton, WIBuilt 1962 · S/N 17249826 N2527LWooten Craig J · Campobello, SCS/N 17255727 N2527YSuazo Tito L · Glendale, AZBuilt 1962 · S/N 17249827 N2528LWings Of Faith · Stevensville, MTBuilt 1966 · S/N 17255728 N2528YHock Adam · Ankeny, IABuilt 1962 · S/N 17249828 N2529UCampbell Alto L III · Pike Road, ALBuilt 1963 · S/N 17250129 N252EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13286 N252ERBeaurayne Holdings LLC · Prairieville, LABuilt 1978 · S/N 17271635 N252JMMccallister Billy G · Virginia Beach, VABuilt 1963 · S/N 17250277 N252RAReynolds Darryl G · Wills Point, TXBuilt 1977 · S/N 17269911 N252SBRoberts Christopher E · Anchorage, AKS/N 17270764 N252SPSkysuite Aviation LLC · Tujunga, CAS/N 172S8228 N2530LSholes Lance M · Oregon City, ORBuilt 1966 · S/N 17255730 N2530YHarbour William T Jr · Mobile, ALBuilt 1962 · S/N 17249830 N2531LAiken Justin M · Arden, NCS/N 17255731 N2532UMills Randall J · Monroe, MIBuilt 1963 · S/N 17250132 N2532YBatie Gregory T · Rogers, ARBuilt 1962 · S/N 17249832 N2534YTorres Gerardo · Gurabo, PRBuilt 1962 · S/N 17249834 N2535YFleck Timothy · Hurst, TXBuilt 1962 · S/N 17249835 N2536LLink Kim D · Golden Valley, NDBuilt 1966 · S/N 17255736 N2536UNeal Tommy G · Sulphur Springs, TXBuilt 1963 · S/N 17250136 N2537LOneill Timothy J · Clyo, GABuilt 1966 · S/N 17255737 N2538UHall Chad B · Baytown, TXBuilt 1963 · S/N 17250138 N2538YChapman James Tod · Portland, ORBuilt 1962 · S/N 17249838 N2539ULoes Todd A · Waterloo, IABuilt 1963 · S/N 17250139 N2539YOly LLC · Onida, SDBuilt 1962 · S/N 17249839 N253EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13310 N253NANeidert Melvin E · Ulysses, KSS/N 29216 N253RAReynolds Darryl G · Wills Point, TXBuilt 1981 · S/N 17274790 N253TSAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13470 N2542UDoak Ronald E · Reno, NVBuilt 1963 · S/N 17250142 N2544YChristianson Cleet M · Enumclaw, WABuilt 1962 · S/N 17249844 N2545YCalifornia Aviation Services Inc · Riverside, CABuilt 1965 · S/N 17252552 N2546YAvquest LLC · Jonesboro, ARBuilt 1962 · S/N 17249846 N2547LDavis Tyler · Laurinburg, NCBuilt 1966 · S/N 17255747 N2547UCostanzo Richard L · Toms River, NJBuilt 1963 · S/N 17250147 N2548UAlt Alexander B · Lockport, NYBuilt 1963 · S/N 17250148 N2548YColbert Robert R · Oroville, WABuilt 1962 · S/N 17249848 N2549LSiemon Mark R · Belle Plaine, MNBuilt 1966 · S/N 17255749 N2549YHerlihy Douglas · Denville, NJBuilt 1962 · S/N 17249849

Back to AD 90-06-03 R1