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.

N5616PKallenberger Ross A · Bakersfield, CABuilt 1959 · S/N 24-684 N5617PBuchheit Dirk · Lake Worth, FLBuilt 1959 · S/N 24-685 N5618ZNull Clifford M · Punxsutawney, PABuilt 1962 · S/N 22-9430 N5622PBaker Franklin E · Montgomery, ILBuilt 1959 · S/N 24-691 N5622YStephan Jesse A · Richmond, TXBuilt 1964 · S/N 27-2732 N5623ZQuinlan John H · Claxton, GABuilt 1962 · S/N 22-9435 N5624PCobb Jeremiah B · Colorado Springs, COBuilt 1959 · S/N 24-693 N5625ZBellamy John Mark · Freeville, NYBuilt 1962 · S/N 22-9437 N5628PMiller Space A · Simi Valley, CABuilt 1959 · S/N 24-698 N5629PVick Josh K · Brentwood, TNS/N 24-699 N5629YTart John W · Fayetteville, NCBuilt 1964 · S/N 27-2741 N5630PWick Eric J · Three Lakes, WIBuilt 1959 · S/N 24-700 N5631PNeal Brian C · Monrovia, CABuilt 1959 · S/N 24-701 N5631ZMooney Timothy · Hedgesville, WVBuilt 1962 · S/N 22-9443 N5632ZEakin Andrew C · Franklin, PABuilt 1962 · S/N 22-9444 N5634PWaters George A · Oklahoma City, OKBuilt 1959 · S/N 24-704 N5636ZYoung Harold E · Jamestown, NYS/N 22-9448 N5637PSellman Richard · Chadron, NEBuilt 1959 · S/N 24-707 N5637ZKutcher Dennie L · Galeton, COBuilt 1962 · S/N 22-9449 N5641ZScout Aviation LLC · Arnaudville, LAS/N 22-9460 N5643PRed Cardinal Aviation LLC · Chantilly, VABuilt 1959 · S/N 24-713 N5644YGantt William M · Port Orange, FLBuilt 1965 · S/N 27-2758 N5644ZVon Drashek Bruce P · Prior Lake, MNBuilt 1962 · S/N 22-9461 N5645PDeines E Jay · Wa Keeney, KSBuilt 1954 · S/N 24-715 N5649YPotenza Austin · Phoenix, AZBuilt 1964 · S/N 27-2764 N5649ZDyson Keith A · Port Townsend, WABuilt 1962 · S/N 22-9472 N5651PSeremet Cristina L · Beaver Dam, WIBuilt 1959 · S/N 24-722 N5652ZClifford Karl N · Lubbock, TXBuilt 1962 · S/N 22-9475 N5653PBeasley Charles R · Lumberton, NCBuilt 1959 · S/N 24-724 N5654PLiebrecht Dennis L DBA · Ocala, FLBuilt 1959 · S/N 24-725 N5655ZTroth Gary D · Mound City, KSBuilt 1962 · S/N 22-9478 N5656PTaylor National Transportation LLC · Palatine, ILBuilt 1959 · S/N 24-727 N565RBEastern Kentucky University · Richmond, KYBuilt 2012 · S/N 4496307 N56635Danley Brothers Inc · Willows, CABuilt 1973 · S/N 36-7360063 N5665ZPerez John-Henry · Locust Grove, GABuilt 1962 · S/N 22-9488 N5666ZWheeler James R · Falling Waters, WVBuilt 1962 · S/N 22-9489 N566BSSand Farm Management Services LLC · Adel, IABuilt 1970 · S/N 39-56 N5670PBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 24-742 N5671YShore Gerry · Inez, TXBuilt 1965 · S/N 27-2785 N5671ZQualls William C · Wellsville, KSBuilt 1962 · S/N 22-9495 N5674PNeely Antwuan T · Savoy, ILBuilt 1959 · S/N 24-746 N5675PLandolt Gregg E · Moreno Valley, CAFirst renewal noticeBuilt 1959 · S/N 24-747 N5676ZHenderson Joseph C · Midlothian, VABuilt 1963 · S/N 22-9502 N5678PWhite John O · Camarillo, CABuilt 1959 · S/N 24-750 N5679PKuehnert Stefan · Clarkesville, GABuilt 1959 · S/N 24-751 N567FLRidgeline Assets LLC · Wilmington, DEBuilt 2026 · S/N 4496643 N567TCRegistration Pending · Platteville, WIRegistration pending, pending cancellationBuilt 1970 · S/N 39-63 N5681ZCalvert Scott R · Pequannock, NJBuilt 1962 · S/N 22-9508 N5683YCaribbean Flyer LLC · Kinshill, VIBuilt 1965 · S/N 27-2799 N5683ZPalmenteri Louis · Rhome, TXBuilt 1962 · S/N 22-9512

Back to AD 85-02-05 R1