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.

N4515YArthur Aviation LLC · Arthur, NDBuilt 1966 · S/N 25-4148 N4517AShepherd Joseph Gary · Sharpsburg, GABuilt 1956 · S/N 22-3823 N4517YHoffmann Earl R Jr · Wildwood, MOBuilt 1966 · S/N 25-4167 N4518AJensen Dustin C · Santa Clara, UTS/N 22-3824 N4518ZHoecher Robert T · Anchorage, AKBuilt 1960 · S/N 22-8020 N451MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 4496547 N4520ACoogan Timothy J · Anchorage, AKBuilt 1957 · S/N 22-3827 N4521YKron Howard H · Clara City, MNBuilt 1966 · S/N 25-4072 N4521ZWeichert Eric S · Janesville, MNBuilt 1960 · S/N 22-8008 N4522ABryant Stephen · Anchorage, AKS/N 22-3829 N4522YAerial Messages Leasing Co · Longwood, FLBuilt 1966 · S/N 25-4030 N4525PFlying L Aircraft Inc · Fort Denaud, FLBuilt 1960 · S/N 27-29 N4526AMathews William A · Albuquerque, NMBuilt 1956 · S/N 22-3834 N4526ZArmstrong Brandon M · Sierra Vista, AZBuilt 1961 · S/N 22-8029 N4527AMacking Craig P · Sepulveda, CABuilt 1956 · S/N 22-3835 N4528PCartagena Carlos A · Sierra Vista, AZBuilt 1960 · S/N 27-32 N4529ACoffey County Airport · Burlington, KSBuilt 1956 · S/N 22-3838 N4529PAeroclub Management LLC · Cincinnati, OHBuilt 1960 · S/N 27-33 N4529ZDaigle Michael R · Andover, NHBuilt 1961 · S/N 22-8032 N4530YSchindler Rick M · Neligh, NEBuilt 1966 · S/N 25-4143 N4530ZKirby Andrew P · Strattanville, PABuilt 1960 · S/N 22-8035 N4531PDelta Sierra LLC · Naples, FLS/N 27-35 N4531ZFelts Jacob I · Kalispell, MTBuilt 1960 · S/N 22-8036 N4532ARasmussen Duane T · Culbertson, MTBuilt 1956 · S/N 22-3841 N4533AMount David B · Fairbanks, AKBuilt 1956 · S/N 22-3842 N4533ZDavis Taylor M · Doylestown, PABuilt 1961 · S/N 22-8038 N4534ZKay Bennie L · Brigham City, UTBuilt 1960 · S/N 22-8039 N4538AHughes William L · Fort Worth, TXFirst renewal noticeBuilt 1956 · S/N 22-3847 N4538YKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1967 · S/N 25-4184 N4539ASvenningsen Joshua J · Menomonie, WIBuilt 1956 · S/N 22-3848 N453CBDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-2573 N453MKNorth Star Aviation · Mankato, MNBuilt 2024 · S/N 4496579 N4540ABeard Ryan Christopher · Oconomowoc, WIS/N 22-3849 N4540ZBerdine Kenneth B · Arnoldsburg, WVBuilt 1961 · S/N 22-8045 N4542ZWaters Caleb M · Merritt Island, FLBuilt 1961 · S/N 22-8047 N4543ZSvec Adolph Ralph · Marengo, ILBuilt 1961 · S/N 22-8048 N4544APhoenix Stephen R · Olympia, WABuilt 1956 · S/N 22-3853 N4544ZTinker David G · Emlenton, PABuilt 1961 · S/N 22-8049 N4546ZPutter Jerry · Wellington, KSBuilt 1961 · S/N 22-8051 N4547AJones Richard F · T Or C, NMBuilt 1956 · S/N 22-3856 N4548APue Thomas A · Marshfield, WIBuilt 1956 · S/N 22-3857 N454ABAerial Banners North Inc · Pembroke Pines, FLBuilt 1974 · S/N 25-7556048 N4550YMiller Andy D · Marana, AZS/N 25-4201 N4552AHall Mark R · New Smyrna Beach, FLBuilt 1956 · S/N 22-3862 N4552PCape Fear Aviation Maintenance LLC · Fayetteville, NCS/N 27-58 N4553ZRisbon Scott W · Crystal Spring, PABuilt 1961 · S/N 22-8058 N4555ALifetime Adventures LLC · Bellevue, MIBuilt 1956 · S/N 22-3866 N4555ZScottini Ryan M · Kent, OHBuilt 1961 · S/N 22-8060 N4556AScott Brent A · Fulton, MOS/N 22-3867 N4557ABuskey Walter B · Etna, NHBuilt 1956 · S/N 22-3868

Back to AD 85-02-05 R1