Skip to content

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.

N6168DMadison James E · Concord, CABuilt 1957 · S/N 22-4815 N6169PKlier John M · Alpine, CABuilt 1959 · S/N 24-1270 N6169YWiesen Enterprises Ltd · Empire, MIBuilt 1966 · S/N 27-3317 N616AMartin Andrew D · Odessa, FLBuilt 1951 · S/N 22-19 N616SRBarendregt Melvin E · Heyburn, IDS/N 24-1800 N6170PMaurer Bruce C · Power, MTBuilt 1959 · S/N 24-1271 N6170YGe Org Advanced Systems LLC · Newton, NJBuilt 1966 · S/N 27-3391 N6173DArs Logistics LLC · Hackettstown, NJBuilt 1957 · S/N 22-4820 N6173PSwenson James A · Lake Point, UTBuilt 1959 · S/N 24-1274 N6174ADakota Air Spray LLC · Huron, SDS/N 36-8102016 N6174DOtoole Makena · Cordova, AKBuilt 1957 · S/N 22-4821 N6174PAbernathy Larry D · Vernon, TXBuilt 1959 · S/N 24-1275 N6175ZSpot-Air LLC · Burlington, TXBuilt 1959 · S/N 25-208 N6176DSawyer Stephen W · Brigham City, UTBuilt 1957 · S/N 22-4823 N6178PFolse Eldred J · North Las Vegas, NVBuilt 1959 · S/N 24-1280 N617EDMente Charles · Homestead, FLBuilt 1968 · S/N 24-4765 N6180YChilton Leonard Jay · Caddo Mills, TXS/N 27-3406 N6181PLowe David M · Sacramento, KYBuilt 1959 · S/N 24-1283 N6184PCollins Michael J · Chandler, AZBuilt 1959 · S/N 24-1286 N6187PFlowers Ricky B · Klamath Falls, ORBuilt 1959 · S/N 24-1289 N6189YSmith Brian Charles Jr · Lake Mary, FLBuilt 1966 · S/N 27-3415 N6189ZHall William B · Vincentown, NJBuilt 1960 · S/N 25-223 N6192PLevin Sidney M · Buffalo Grove, ILBuilt 1959 · S/N 24-1294 N6193YMatthews Aviation LLC · Hardinsburg, KYBuilt 1966 · S/N 27-3419 N6194PCrosby Tire & Body Shop Inc · Crosby, NDBuilt 1959 · S/N 24-1296 N6196ZH&H Ag-Aviation Inc · New Underwood, SDBuilt 1960 · S/N 25-230 N6198HLane Aviation Inc · Rosenberg, TXS/N 25-5419 N619BLPacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554003 N61BBAeronautical Technical Service Inc · Collierville, TNS/N 30-875 N61MGDominion Air Charter Inc · Louisa, VABuilt 1974 · S/N 277405285 N61NCNorthwest Florida Flight Services LLC · Jacksonville, FLS/N 27-4184 N61TPPalmer Blake A · Knoxville, TNBuilt 1961 · S/N 22-8162 N61UComanche Skye LLC · Savannah, GABuilt 1966 · S/N 30-1004 N6200ZAerial Banners Inc · Pembroke Pines, FLBuilt 1960 · S/N 25-234 N6202PCollins Owen Stewart · Toccoa, GAS/N 24-1303 N6203PClark Jason H · Ridgecrest, CABuilt 1959 · S/N 24-1304 N6203ZKnutson Wayne R · Tioga, NDBuilt 1960 · S/N 25-241 N62052Bolinger Ray G · Kuna, IDBuilt 1959 · S/N 24-1235 N6205PTwo Dot Aircraft Ll · Kalispell, MTS/N 24-1307 N6205YMarschke Corey A · Stevens Point, WIBuilt 1966 · S/N 27-3432 N6207PSquawk 2310 LLC · Ridgefield, WABuilt 1959 · S/N 24-1309 N6208ZBenz Aviation LLC · Ionia, MIBuilt 1960 · S/N 25-246 N6210PHolbrook Glen A · Marion, WIFirst renewal noticeBuilt 1959 · S/N 24-1312 N6211PPounds Kenneth M · Pueblo West, COBuilt 1959 · S/N 24-1313 N6212PJobin Lyle S · Madeira Beach, FLBuilt 1959 · S/N 24-1314 N6216PDuvall James Grafton III · Silver Springs, NVBuilt 1959 · S/N 24-1318 N6216XCentral Alabama Soaring Association · Birmingham, ALBuilt 1964 · S/N 25-3110 N6218PSmith Ron E · Goodlettsville, TNBuilt 1959 · S/N 24-1320 N6218ZLorenzo Ag Air Inc DBA · Lorenzo, TXBuilt 1960 · S/N 25-258 N6219YTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1966 · S/N 27-3446

Back to AD 85-02-05 R1