Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N80WTOtter Creek Lodge LLC · Big Timber, MTBuilt 1976 · S/N 18052784 N8102MShannon Michael E · Richland, WAS/N 18264540 N8102ZCrestview Estate LLC · Greenwood, SCBuilt 1962 · S/N 205-0102 N8103ZProsser Joel R · Sacramento, CABuilt 1962 · S/N 205-0103 N8104MMakati 121 LLC · Las Vegas, NVBuilt 1976 · S/N 18264541 N8104ZNegris James R · Mazama, WABuilt 1962 · S/N 205-0104 N8105MSudworks Aviation LLC · Ardmore, OKBuilt 1976 · S/N 18264542 N8106ZWilliamson Gary S · Lakeport, CABuilt 1962 · S/N 205-0106 N8107ZReid Brian M · Boise, IDBuilt 1962 · S/N 205-0107 N810CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281247 N810JVCarstensen Ross J · Waterloo, NEBuilt 1960 · S/N 50784 N810RFQuiring Mark Edmond · Mount Pleasant, TXBuilt 2012 · S/N 18282329 N810WSky-Pirates LLC · Deland, FLBuilt 1958 · S/N 51691 N8110VN8110v LLC · Havana, FLBuilt 1968 · S/N 188-0360 N8111ZSchmitts Air Inc · Enumclaw, WABuilt 1962 · S/N 205-0111 N8112ZTobias Aaron C · Clearwater, KSBuilt 1962 · S/N 205-0112 N8115EGrillos Emmanuel John II · Kent, WABuilt 1984 · S/N 18268386 N8116GJrb12 Inc · Shorewood, ILBuilt 1971 · S/N 21059416 N8116ZJohnston Joshua R · Scappoose, ORS/N 205-0116 N811AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281196 N811AHOtv Leasing · Manassas, VABuilt 2010 · S/N 18282240 N811CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281248 N811ECChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1975 · S/N 21060702 N811GWGreat Western Aviation Leasing LLC · Ogden, UTBuilt 2002 · S/N 18281101 N811LLLa Vida Aviation LLC · Lake Bluff, ILBuilt 1977 · S/N 18266165 N811TWNova Aircraft Holdings Inc · San Diego, CABuilt 2002 · S/N 18281118 N811XArkoma Aviation LLC · Henryetta, OKBuilt 1966 · S/N T210-0068 N8120ZMechelay Joseph J · Pampa, TXBuilt 1962 · S/N 205-0120 N8121GTwo One Golf Ltd · Waterloo, IABuilt 1971 · S/N 21059421 N8123GBlattmachr Matthew · Anchorage, AKS/N U20603770 N8123Q8123q LLC · Olympia, WABuilt 1975 · S/N U20603093 N8123ZGray Bryan D · Colorado City, TXBuilt 1962 · S/N 205-0123 N8125MDobson Air Enterprise LLC · College Station, TXBuilt 1976 · S/N 18264543 N8125ZM E M Enterprises · Friday Harbor, WABuilt 1962 · S/N 205-0125 N8126ZBarber Jonathan D · Payson, AZBuilt 1962 · S/N 205-0126 N8127L2f Trade LLC · Gainesville, TXS/N 21060614 N8128LSayco Aviation LLC · Fayetteville, GABuilt 1974 · S/N 21060615 N8128MSchwartz Donald G · Elroy, WIBuilt 1976 · S/N 18264544 N8129GJohnson Richard A Trustee · Chandler, AZBuilt 1971 · S/N 21059429 N8129ZRhodes Steve A · Auburn, CAS/N 205-0129 N812AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281197 N812KKKerscher Helen A · Los Lunas, NMBuilt 1974 · S/N 18262759 N812KRSchneider Richard A · Ellicott City, MDBuilt 1978 · S/N 18266016 N812MCFly Bye Air LLC · Southport, NCBuilt 2003 · S/N 18281208 N812PLCirrusair LLC · Missoula, MTBuilt 1975 · S/N 18263781 N812WJjc Enterprises Inc · Dillingham, AKBuilt 1975 · S/N U20602770 N8130LPerfect 10 Roofing · Billings, MTS/N 21060617 N8130ZChalmers Russell P · Saint Martinville, LABuilt 1962 · S/N 205-0130 N8131GTalley Edward P · San Jose, CABuilt 1971 · S/N 21059431 N8132ZCrown L Inc · Greenacres, FLBuilt 1962 · S/N 205-0132

Back to AD 84-10-01 R1