Registered aircraft · 8,920

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.

N6904ALesser Antilles Corp Trustee · Wilmington, DEBuilt 1979 · S/N 27-7954076 N6904DLucas Michael F · Germantown, OHS/N 22-4831 N6904KHolcomb Garry M · Point, TXS/N 20-33 N6904YUnited Jet Sales Inc · Newark, DEBuilt 1969 · S/N 27-4259 N6905DEvans Theresa K · Alexandria, MNBuilt 1957 · S/N 22-4832 N6905PMampel Gregory J · New Port Richey, FLBuilt 1960 · S/N 24-2039 N6906KWilliams Don D · Athens, ALS/N 20-9 N6906PKapeller James A · Wickenburg, AZFirst renewal noticeBuilt 1960 · S/N 24-2040 N6907BJordan Walter B · Chehalis, WABuilt 1956 · S/N 22-4182 N6907PHolbein Mark A · Freeport, PAS/N 24-2041 N6908KRegistration Pending · Dillingham, AKRegistration pendingBuilt 1950 · S/N 20-12 N6909BKaufmann Arnold L · Davenport, IABuilt 1956 · S/N 22-4184 N6909KJersey Devil Dusters LLC · Southampton, NJBuilt 1950 · S/N 20-14 N6909PWest Texas Weather Modification Association · San Angelo, TXBuilt 1960 · S/N 24-2043 N690BLincwings Society LLC · Austin, TXBuilt 1955 · S/N 23-382 N690RGRegistration Pending · Gurabo, PRRegistration pendingBuilt 1969 · S/N 274260 N6910DWood Robert A · Sheboygan, WIBuilt 1957 · S/N 22-4837 N6911KHatley Sean P · Mount Horeb, WIBuilt 1950 · S/N 20-16 N6911YDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1969 · S/N 27-4266 N6912PAnzaldua Johnny J · Midland, TXFirst renewal noticeBuilt 1960 · S/N 24-2046 N6913ANorthwoods Air LLC · Orono, MEBuilt 1979 · S/N 27-7954108 N6913BKeyt Jeffrey D · New Providence, NJBuilt 1956 · S/N 22-4188 N6913KMedcroft Sean M · Edmonds, WABuilt 1950 · S/N 20-6 N6914BLark Bradley J · Enoch, UTBuilt 1956 · S/N 22-4189 N6916KBrown Daniel A · Gettysburg, PABuilt 1950 · S/N 20-18 N6916YDk1 Aviation LLC · Fayetteville, NCBuilt 1969 · S/N 27-4272 N6917APiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 27-7954111 N6918DTucker Christopher W · Johnstown, COBuilt 1962 · S/N 23-2038 N6919BPolyclinics.Net LLC · Hixson, TNS/N 22-4194 N6919PMunroe Consulting · Ocala, FLBuilt 1962 · S/N 24-3143 N6920PStanley Travis Navar · Dundee, OHBuilt 1960 · S/N 24-2054 N6921BKnepp Gerald L · Milroy, INBuilt 1956 · S/N 22-4197 N6923BWitzel John F Jr · Frenchglen, ORBuilt 1956 · S/N 22-4199 N6923DCline Patrick G · Granbury, TXBuilt 1957 · S/N 22-4851 N6923KLeocha Anthony J · Hampstead, NHBuilt 1950 · S/N 20-26 N6923PLopez Ruben Arellano · Nogales, AZS/N 24-2057 N6924PLauderback Lee L · Fort Collins, COBuilt 1960 · S/N 24-2058 N6926DGibson Christopher R · Natchez, MSBuilt 1957 · S/N 22-4854 N6926KRed Wolf Aviation LLC · Venice, FLBuilt 1950 · S/N 20-28 N6927KLord Mary E · Kalama, WABuilt 1950 · S/N 20-29 N6928DRegistration Pending · West Yellowstone, MTRegistration pendingBuilt 1957 · S/N 22-4856 N6928POwen Colin Jc · College Station, TXBuilt 1960 · S/N 24-2062 N6929DJohnson Timothy D · Chapel Hill, NCBuilt 1957 · S/N 22-4857 N692CFG&M Aircraft Inc · Wheat Ridge, COS/N 44-7995024 N6931DThomas Isaac F · Portland, ORBuilt 1957 · S/N 22-4859 N6931KValiair Limited Co Trustee · Casper, WYBuilt 1950 · S/N 20-35 N6932BHauser Nathan · Newark, DEBuilt 1956 · S/N 22-4210 N6932KHodge Tyler · Prattville, ALBuilt 1950 · S/N 20-36 N6932PMartenson Matthew J · Elgin, SCBuilt 1960 · S/N 24-2066 N6933DRegistered aircraftBuilt 1957 · S/N 22-4861

Back to AD 85-02-05 R1