Skip to content

Registered aircraft · 26,231

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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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.

N4572EMescher Daniel R · Yuba City, CABuilt 1949 · S/N 7CCM-138 N45732Registration Pending · Plains, MTRegistration pendingBuilt 1946 · S/N 2259 N4573ECheatum Jamie K · Salina, KSBuilt 1949 · S/N 7CCM-139 N4573UMulder Timothy D · Shafter, CAS/N 15060573 N4574ECarlisle Kevin · Sheridan, INBuilt 1947 · S/N 7CCM-140 N4574UAirmotive Service LLC · Brigham City, UTBuilt 1964 · S/N 15060574 N4575ECraig John S Jr · Glenburn, MEBuilt 1949 · S/N 7CCM-142 N45765Jhaco LLC · Lake Charles, LAS/N 2292 N45767Weber Loren B · Virginia Beach, VAS/N 2294 N4576CFrench David C · Mc Alpin, FLBuilt 1953 · S/N 25520 N4577AThompson Dennis E Jr · Anchorage, AKBuilt 1956 · S/N 18-4883 N4577CKoinzan Seed And Flying Service Inc · Elgin, NEBuilt 1953 · S/N 25521 N4577HAllen Mark C · Redding, CABuilt 1948 · S/N 15-351 N4578EBlight Andrew J · Endwell, NYBuilt 1949 · S/N 7CCM-148 N4578JCore Tech Services And Supply LLC · Odessa, FLBuilt 2009 · S/N 4326 N4578MKennedy Ken · Lubbock, TXBuilt 1947 · S/N 11-81 N45790Kilbarger Shawn · Jamestown, OHS/N 559 N4579AReid Melissa K H · Anchorage, AKBuilt 1956 · S/N 18-4885 N4579MRopp Douglas L · Albany, ORBuilt 1947 · S/N 11-82 N4579USquiers Frederick Eugene · Barre, VTS/N 15060579 N457AESahni Irvin K · Seguin, TXBuilt 1967 · S/N 15066592 N457GGBohl Howard M · Temecula, CAS/N 15060269 N45803Lindberg David D · Everett, WABuilt 1946 · S/N 2330 N45804Registered aircraftAssigned, pending cancellationS/N 2331 N4580UDean Nolan W · Harrisonburg, VABuilt 1964 · S/N 15060580 N4581CGerardy Harlan D · Gruver, TXBuilt 1953 · S/N 25525 N4582CBontrager Brian S · Wasilla, AKBuilt 1953 · S/N 25526 N4582HAnderson Irvin A · Chandler, AZBuilt 1948 · S/N 17-7 N4583CWood L Paul · Bridgeport, TXS/N 25527 N4583ECheatham Glenn W J · Hot Springs, SDBuilt 1949 · S/N 7CCM-152 N45846Anaya Luis F · Hermosa Beach, CAS/N 156 N4584CEco Resources Inc · Millersport, OHBuilt 1953 · S/N 25528 N4584UDavis Jubal L · Waverly, OHBuilt 1964 · S/N 15060584 N4585CTempero Clair R · Worden, MTBuilt 1953 · S/N 25529 N4586EAinslie James A · Richfield Springs, NYBuilt 1949 · S/N 7CCM-158 N4586UCate Randall L · Knoxville, TNFirst renewal noticeBuilt 1964 · S/N 15060586 N4587CJackson Marshall L II · Rock Hill, SCBuilt 1953 · S/N 25531 N4587HJohnson Steven Donald · Pardeeville, WIBuilt 1948 · S/N 17-3 N45889Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 227 N4589CNelson David W · Marengo, ILBuilt 1953 · S/N 25533 N4589MMorris Jerry W · Deer Trail, COBuilt 1947 · S/N 11-92 N45911Lee Ronald C · Bronwood, GABuilt 1946 · S/N 2438 N4591ERichards S G · North Palm Beach, FLBuilt 1949 · S/N 7DC-156 N4591MPlayer Virginia P · Valdosta, GAS/N 11-94 N4591UJacobsen Ian M · Lincoln City, ORBuilt 1964 · S/N 15060591 N4592CKelley Stephen Mark · Kamiah, IDBuilt 1953 · S/N 25536 N4593MSmith Terry G · Wallowa, ORBuilt 1947 · S/N 1196 N4594MPilster Ranch Corp · Alzada, MTBuilt 1947 · S/N 11-97 N4594UMclendon Michael L · Whitesboro, TXBuilt 1964 · S/N 15060594 N4595CYoussefzadeh Salim · Pls Vrds Est, CABuilt 1953 · S/N 25539

Back to AD 94-05-05 R1