Skip to content

Registered aircraft · 11,723

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:83-22-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-22-06') 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:83-22-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-22-06')
  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:83-22-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-22-06')
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.

N1001VLawson Justin Chadwick · Watkinsville, GABuilt 1976 · S/N R1722074 N1004VSalt Aerial Aviation LLC · Hamel, MNBuilt 1976 · S/N R1722075 N1005FBeam Douglas J Trustee · Chugiak, AKBuilt 1975 · S/N 18502677 N100CAFass Flyers LLC · Garden Ridge, TXBuilt 1978 · S/N 18266536 N100QBShutt Ryan T · Eden, NYBuilt 1979 · S/N R18201185 N1014FPeppard Kenneth W · Dumfries, VABuilt 1979 · S/N 17272931 N1014TInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201650 N1015FInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18502684 N1016FFly Cadillac LLC · Tustin, MIS/N 17272932 N1016VPlowright Aviation LLC · Aldie, VAS/N R1722082 N1018HGulf Air Group Inc · Crestview, FLBuilt 1980 · S/N R18201649 N1019FFly By Aviation LLC · Sun Valley, CABuilt 1979 · S/N 17272933 N101ATZrelak Patrick DBA · Apple Valley, CABuilt 1977 · S/N 15280208 N101KTBryan Jerry E · Kathleen, GABuilt 1978 · S/N 18266264 N101SPHawkes Clark · Gillsville, GABuilt 1986 · S/N 18268562 N1022FGoodfellow Malcolm D · Seattle, WABuilt 1975 · S/N 18502690 N1023FWinter Karl · Litchfield Park, AZBuilt 1975 · S/N 18502691 N1025VAviation Partners LLC · Highlands Ranch, COBuilt 1976 · S/N R1722086 N1028FLunoe Leif C · Anchorage, AKBuilt 1975 · S/N 18502695 N102ACWindfall Capital Ventures LLC · Westerville, OHS/N 17271882 N102UCWest Valley Flying Club · Palo Alto, CABuilt 1980 · S/N 15284832 N1031SRedmon James A · Frisco, TXBuilt 1977 · S/N 15279996 N1032VMatlock Jimmy R · Granbury, TXBuilt 1976 · S/N R1722088 N103ALJordan John S · Sullivan, MOBuilt 1977 · S/N 0599 N103AMN103am LLC · Chehalis, WABuilt 1974 · S/N 18502615 N103ASHill Bryan Thomas · Page, AZBuilt 1979 · S/N R18200923 N103UC426th Aero Squadron LLC · Cropwell, ALBuilt 1980 · S/N 15284243 N1040FMarrs Matthew D · Bentonville, ARBuilt 1975 · S/N 18502697 N1040PShogren Dennis · Grand Terrace, CAS/N R18200368 N1040VWilliamson Peter D · Houston, TXBuilt 1976 · S/N R1722090 N1041SN1041s LLC · Key West, FLBuilt 1977 · S/N 17268658 N1042SPiper Cameron · Winchester, VABuilt 1977 · S/N 172-68662 N1043FBakkes Francois · Sitka, AKBuilt 1975 · S/N 18502700 N1043SAmerican Aviator LLC · Newark, DEBuilt 1977 · S/N 172-68679 N1047FBondurant Jok · Talkeetna, AKS/N 18502704 N104BWJurak Mike D · Kimberly, IDBuilt 1974 · S/N 18502517 N104DEVince John G · West Ossipee, NHBuilt 1980 · S/N 18504009 N104HEDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1975 · S/N 18502742 N104JSSmith Timothy A · Shafter, CABuilt 1977 · S/N 18265625 N104TRAuburn Sheet Metal Inc · Enumclaw, WABuilt 1976 · S/N 18503212 N104UCAspiring Aviators Aero Club · Winter Haven, FLS/N 15284673 N1050FBuchan John F · Port Ludlow, WABuilt 1975 · S/N 18502707 N1052FGlb Farms Inc · Pasco, WABuilt 1975 · S/N 18502709 N1054VNorthington Neill · Fredericksburg, TXBuilt 1976 · S/N R1722094 N1055VWarner Alan P · Carpinteria, CABuilt 1976 · S/N R1722095 N1056FBrasil John I · Lemon Grove, CABuilt 1975 · S/N 18502712 N1057FBoldflight LLC · Bargersville, INBuilt 1979 · S/N 17272939 N1058VPelfrey Earl T · Crossville, TNBuilt 1976 · S/N R1722097 N105AAWehrmacher James P · Crawford, COBuilt 1978 · S/N R18200483 N105JKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 17275306

Back to AD 83-22-06