Skip to content

Registered aircraft · 3,118

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:82-23-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:82-23-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:82-23-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:82-23-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:82-23-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:82-23-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.

N8407YAwad Aviation LLC · Pooler, GABuilt 1967 · S/N 30-1557 N8408PBeavers Jeffrey · Metairie, LABuilt 1964 · S/N 24-3664 N8409PStevenson Gregory J · Sutter Creek, CABuilt 1964 · S/N 24-3665 N8416YHenze Charles R · Waukee, IABuilt 1967 · S/N 30-1567 N8417P250 Dash 4 Associates Ltd · Yellow Springs, OHBuilt 1964 · S/N 24-3669 N8418YHefner Joseph C · Mount Pleasant, TXS/N 30-1570 N8419YMorrone Richard W · Westerly, RIS/N 30-1572 N841PSLivin The Dream Aviation LLC · Jupiter, FLBuilt 1967 · S/N 24-4684 N8421YKesser Gilbert M · Culpeper, VABuilt 1967 · S/N 30-1575 N8422PAnderson William · Creve Coeur, ILBuilt 1964 · S/N 24-3672 N8427YBiernacki David F · Rockford, ILBuilt 1967 · S/N 30-1584 N8428PBertling Kevin M · Spring, TXBuilt 1964 · S/N 24-3675 N8430YDavid Litteken · Aviston, ILBuilt 1967 · S/N 30-1588 N8431YN8431y LLC · Coatesville, INBuilt 1967 · S/N 30-1589 N8432YTaylor Kyle F · Enterprise, ALBuilt 1967 · S/N 30-1591 N8435YGlobal Aviators Academy Inc · Claremont, CAS/N 30-1595 N843DCJuliet Echo LLC · Sheridan, WYBuilt 1965 · S/N 30-967 N843GR & B Aircraft Holdings LLC · Denham Springs, LABuilt 1969 · S/N 30-1766 N8441AAerolease LLC · Wilmington, DEBuilt 1963 · S/N 30-125 N8443PLeggett Marjy A · Pasco, WABuilt 1964 · S/N 24-3683 N8444YBeacon Aviation Flight Services LLC · Rogers, ARS/N 30-1604 N8447PHenry Thomas Levin · Delmar, DEBuilt 1964 · S/N 24-3684 N844PSDarr James E · Boron, CAFirst renewal noticeBuilt 1967 · S/N 24-4694 N8451PReed James D II · San Antonio, TXBuilt 1964 · S/N 24-3686 N8452YRhodes Cleo B · Dayton, VABuilt 1967 · S/N 30-1611 N8456YCfl Aircraft Sales LLC · Tampa, FLBuilt 1967 · S/N 30-1615 N8458YOakes Michael J · Walnut Creek, CABuilt 1967 · S/N 30-1617 N8468YStone D L · Arlington, TXBuilt 1967 · S/N 30-1629 N846PAfonso Joseph · Wallkill, NYBuilt 1967 · S/N 24-4695 N8475YSolymossy Robert A · Tysons, VABuilt 1967 · S/N 30-1637 N847BRegistration Inc · Kalispell, MTS/N 30-348 N847EDFoster Matthew R · Poplar Grove, ILBuilt 1968 · S/N 30-1692 N8486ZKlompstra John V · Wadsworth, OHBuilt 1963 · S/N 30-227 N8487YAviation Safety Dynamics LLC · Richmond, TXBuilt 1967 · S/N 30-1650 N8489YSorbi Aviation Inc · El Cajon, CABuilt 1967 · S/N 30-1652 N8492YGaipa Timothy A · Saint Joseph, MIBuilt 1967 · S/N 30-1655 N8496YOsiol Russell E · Chicago, ILS/N 30-1297 N84JSKocak Robert G Jr · Peoria, AZBuilt 1966 · S/N 30-1222 N84TDBailey Dennis · Kernersville, NCBuilt 1969 · S/N 30-1951 N84VKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-1492 N8503YRoberti John O · Barre, VTBuilt 1967 · S/N 30-1662 N8505YCli Aerospace LLC · Appleton, WIBuilt 1968 · S/N 30-1665 N8506YWilliams Russell D · Rehoboth Beach, DEBuilt 1967 · S/N 30-1666 N8507YWhiteley Robert L · Pittsburg, CABuilt 1967 · S/N 30-1667 N8512YSager Garrett · Fort Worth, TXBuilt 1967 · S/N 30-1672 N8513YCrane Douglas Gordon · Coquille, ORBuilt 1967 · S/N 30-1673 N8514YMcnally Rodney · Sonora, CABuilt 1967 · S/N 30-1675 N8515YPiper Aviation Museum Foundation · Lock Haven, PABuilt 1967 · S/N 30-1676 N8523YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1684 N8526YCarlile John D · The Villages, FLBuilt 1968 · S/N 30-1687

Back to AD 82-23-01 R1