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.

N508DLonguski Francis J · Vassar, MIBuilt 1946 · S/N 10940 N508JMMunday Jeffrey R Trustee · Waverly, GABuilt 1946 · S/N 8962 N508WLCampbell Robert · Kingman, AZBuilt 1953 · S/N 25897 N50904Karges Kip · Tuscola, TXBuilt 1968 · S/N 15069631 N50909Keystone Aviation Group LLC · Paxinos, PABuilt 1968 · S/N 15069634 N50911Graves Robert E · Danville, INBuilt 1968 · S/N 15069636 N50914Calhoun John R · Baton Rouge, LABuilt 1968 · S/N 15069638 N50915Donato Robert J · East Berlin, PABuilt 1968 · S/N 15069639 N50920Campbell James R · Temple City, CABuilt 1968 · S/N 15069643 N50921Hernandez Jesus C · Elberton, GABuilt 1968 · S/N 15069644 N5092AHansen Aviation LLC · Savannah, GABuilt 1955 · S/N 28092 N5092HHall Joshua M · Kenai, AKBuilt 1949 · S/N 11-994 N50936Qualitair LLC Trustee · MichelstadtS/N 15069656 N50948Salomonsson Mats E · Hayward, CABuilt 1968 · S/N 15069668 N5094QSchuur Ryan C · Chandler, MNBuilt 1993 · S/N 1 N5095Spak Andrew T · Thousand Oaks, CABuilt 1971 · S/N PHS-1P2 N50957Anklam Eugene E · Claremore, OKS/N 15069673 N5095HRender Thomas R · Eden Prairie, MNFirst renewal noticeBuilt 1949 · S/N 11-991 N50960Ortiz Tech LLC · Doral, FLBuilt 1968 · S/N 15069675 N50984Roberts Wayne A Jr · Juneau, AKBuilt 1968 · S/N 15069687 N50989Und Aerospace Foundation · Grand Forks, NDBuilt 1975 · S/N 15077226 N50990Fielden Virgil A · Fairfield, TXBuilt 1968 · S/N 15069693 N50992Flom Tyler M · Evans, GABuilt 1968 · S/N 15069695 N50994Plane Junkies LLC · Dover, DES/N 15069696 N50AVMichigan Cub Ventures LLC · Saline, MIBuilt 2020 · S/N 2020-0201 N50BSSugiono Yudi S · Redlands, CABuilt 1946 · S/N 1118 N50JXDls Holdings Inc · Arlington, TXBuilt 1973 · S/N 15074642 N50KJStephen Kenneth J · Bristol, TNBuilt 2024 · S/N 75-7678 N50PTJackson Michael W · Bedford, TXBuilt 1968 · S/N 15069220 N50TLSmith Lynn D · Roosevelt, UTBuilt 1970 · S/N A1500203 N50XFHdw Florida Helicopters Inc · Pompano Beach, FLS/N 15074345 N51000Jet-I Aviation LLC · Palm City, FLS/N 15069700 N51009Bowers Shane A · Bixby, OKBuilt 1968 · S/N 15069706 N5100APlane Sense Inc · Kindred, NDBuilt 1955 · S/N 28100 N5100FAir & Space Education Instittute Inc · Pine Knot, KYBuilt 1964 · S/N 17251947 N51029Cywan Alex M · Sherman Oaks, CABuilt 1968 · S/N 15069716 N5103AWinkelstein Aaron B · Lehi, UTS/N 28103 N51040Pruitt Benny G · Reidsville, NCBuilt 1968 · S/N 15069721 N51046Weeks Thomas W · Ypsilanti, MIBuilt 1968 · S/N 15069726 N51047Huls Timothy J · Stevensville, MTBuilt 1968 · S/N 15069727 N51048Heermance Timothy Jr · West Palm Beach, FLBuilt 1968 · S/N 15069728 N51052Smithard Austin · Peachtree, GAS/N 15069730 N51059Donadio Gerard J · Ronkonkoma, NYS/N 15069736 N51060Elmore Eric T · Colorado Springs, COS/N 15069737 N51068Hodges Michael D · Glenpool, OKBuilt 1968 · S/N 15069743 N51069Sport Flyer LLC · Jackson, WYBuilt 1968 · S/N 15069744 N51074Donner John R · Clara City, MNBuilt 1968 · S/N 15069747 N5107FFly Idaho LLC · Meridian, IDBuilt 1966 · S/N 17255107 N5107XPhoenix Stephen R · Winnemucca, NVBuilt 1992 · S/N 80-6 N51082Fremont Aviation Inc · Fremont, NES/N 15069750

Back to AD 94-05-05 R1