Skip to content

Registered aircraft · 8,921

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:85-02-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:85-02-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:85-02-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:85-02-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:85-02-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:85-02-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.

N2764PBrine William R · Pahrump, NVS/N 22-3075 N2766PMarti Larry B · Rolla, MOS/N 22-3077 N276JSEagle Flight Academy LLC · Owensboro, KYBuilt 1964 · S/N 30-422 N277DDWicked Flyby LLC · Lewes, DEBuilt 1960 · S/N 24-1818 N2782YDegroff Steven A · Berne, INBuilt 1964 · S/N 26-59 N278AGEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 4496506 N279AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496507 N279CTShelton Paul K · Flushing, NYBuilt 1973 · S/N 31P-7300172 N27BATerrill Dana R · Port Angeles, WABuilt 1952 · S/N 22-819 N27BRLarson Allen L · Capron, ILBuilt 1969 · S/N 24-4909 N27CYSale Reported · Hastings, FLSale reportedBuilt 1976 · S/N 27-7654118 N27FMGogoplex LLC · Wilmington, DEBuilt 1976 · S/N 27-7654087 N27HPTrinair Aviation LLC · Hampshire, ILBuilt 1962 · S/N 27-2034 N27PCRegistration Pending · Houston, TXRegistration pending, pending cancellationBuilt 1962 · S/N 24-3022 N2800ZRitchie John A Jr · Gold Hill, NCBuilt 1959 · S/N 22-6793 N2801ZValiair Limited Company Trustee · Casper, WYBuilt 1959 · S/N 22-6794 N2802ZPeavler Christopher · Modoc, SCS/N 22-6795 N2803PLewis Stephen R · Chillicothe, ILBuilt 1955 · S/N 22-3095 N2808PValiair Limited Co Trustee · Casper, WYBuilt 1955 · S/N 22-3101 N2809PDavis Gerald R · Hernando Beach, FLS/N 22-3102 N280AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496511 N280FGFox Leasing Group LLC · Hollywood, FLBuilt 2021 · S/N 4496525 N28110Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496513 N28114Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496514 N28115Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496515 N2811ZHill Daniel A · Soldotna, AKBuilt 1959 · S/N 22-6804 N2812ZRubbert Randy C · Reynolds, NDS/N 22-6805 N2814ZGibney Paul H · Palmer, MABuilt 1959 · S/N 22-6807 N2815PJohnson Trevor T · Somerset, WIBuilt 1955 · S/N 22-3108 N2818PHancock Timothy R · Malinta, OHBuilt 1955 · S/N 22-3111 N2818ZJohnston Charles W C · Newfield, NJS/N 22-6811 N2819PRector David F · Akron, OHBuilt 1955 · S/N 22-3112 N2821ZLarson Sidner J · Tucson, AZBuilt 1959 · S/N 22-6826 N2823ZKennedy Richard A · Livonia, MIBuilt 1959 · S/N 22-6817 N2825ZBraxling Todd A · Soldotna, AKBuilt 1959 · S/N 22-6819 N2828PWood Levi S · Anchorage, AKBuilt 1955 · S/N 22-3121 N2828ZWalters Thomas M · Lyman, WYBuilt 1959 · S/N 22-6823 N282PGitlow Stuart · Woonsocket, RIBuilt 1964 · S/N 30-508 N2833ZVaughn James F · La Porte, INS/N 22-6828 N2834PStevens Constance I · Homewood, CABuilt 1955 · S/N 22-3127 N2836PWells Michael D · Wilton, MEBuilt 1955 · S/N 22-3133 N2838ZHanrahan Andrew D · Soldotna, AKBuilt 1959 · S/N 22-6833 N2839DWhitehead Mark A · Valley Springs, CABuilt 1951 · S/N 22-244 N283CAVero Technical Support Inc · Pensacola, FLBuilt 1979 · S/N 44-7995225 N2840PBourne Steven M · Brooksville, FLBuilt 1955 · S/N 22-3137 N2841ZVan Ryn William C · Hermiston, ORBuilt 1959 · S/N 22-6836 N2842PEaster Brett D · Enumclaw, WABuilt 1955 · S/N 22-3139 N2844PZiller Michael W · Hudson, ILBuilt 1955 · S/N 22-3144 N2845ZKrause Douglas F · Stacy, MNBuilt 1959 · S/N 22-6840 N2846PWilliamson Gary · Ashmore, ILBuilt 1955 · S/N 22-3146

Back to AD 85-02-05 R1