Skip to content

Registered aircraft · 54,015

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

N7609FKomberec Eric R · Kalispell, MTBuilt 1979 · S/N 17273267 N7609MYoung Robert D · Georgetown, DEBuilt 1959 · S/N 55909 N7609QPierson Janice R Trustee · Scio, ORBuilt 1978 · S/N 18503626 N7609SButzbaugh Elden W Jr · Saint Joseph, MIBuilt 1976 · S/N 18265257 N7609THall Donald P · Anacortes, WABuilt 1959 · S/N 47209 N760CAMcculloch Matthew L · Stoutland, MOBuilt 1975 · S/N 15076356 N7610AScrap Materials Inc · Huntington, ARS/N A1520738 N7610CSawtooth Flying Service Inc · Mccall, IDBuilt 1977 · S/N U20603924 N7610GFalconer Robert H · Yolo, CABuilt 1970 · S/N 17259310 N7610MEickhoff Steven M · Fountain, MNBuilt 1977 · S/N 21062030 N7610TDines Stephen R · Monument, COBuilt 1965 · S/N 47210 N7610XShezifi Mathew · Livermore, CABuilt 1977 · S/N R18200113 N7611FGeneral Aviation Support Corp · Rosamond, CAS/N 17273269 N7611GStaunton Curtis J · Tulelake, CABuilt 1970 · S/N 17259311 N7611SMile High Advertising Inc · Doylestown, PABuilt 1976 · S/N 18265259 N7612GSwartwood Thomas C · Everson, WABuilt 1970 · S/N 17259312 N7612KDeblack Richard B · Crosslake, MNBuilt 1976 · S/N 18052689 N7612MHall Adam Patrick · Borrego Springs, CABuilt 1959 · S/N 55912 N7612TBabcock Douglas O · Chesterton, INBuilt 1960 · S/N 47212 N7614VTucker Aviation LLC · Kalispell, MTBuilt 1976 · S/N 177RG0891 N7615AUpton Michael James · Anchorage, AKBuilt 1956 · S/N 32512 N7615GWashington Samuel C · Washington, DCS/N 17259315 N7615NHelms Aviation Inc · Long Lake, NYBuilt 1977 · S/N U20603706 N7615TN Maple LLC · Kalispell, MTS/N 47215 N7615XEagle Flight Inc. · Fremont, NEBuilt 1960 · S/N 17248115 N7616KHarrison William Thomas · West Richland, WAFirst renewal noticeS/N 18052690 N7616MGriffin Robert L Jr · Washington, NCBuilt 1959 · S/N 55916 N7616NFox Tim · Obion, TNBuilt 1974 · S/N 18263274 N7616UShepard Gregory W · Fort Myers, FLBuilt 1975 · S/N 15077770 N76172Rjd Flight LLC · North Canton, OHBuilt 1975 · S/N 17265906 N76177Brown Emily D · Niceville, FLBuilt 1975 · S/N 177RG0817 N7617URikki Air LLC · Clarksville, TXBuilt 1975 · S/N 15077771 N76182Vaughan Steven T · Overland Park, KSBuilt 1976 · S/N 18264888 N76185Snell Marion Lea · Ackerly, TXS/N 18503013 N7619GMercer Aviators Inc · Princeton, WVBuilt 1970 · S/N 17259319 N7619NAir Alday LLC · Pompano Beach, FLBuilt 1974 · S/N 18263277 N7619XWeitzel Claus P · Newington, GABuilt 1960 · S/N 17248119 N761AFranz Construction Inc · Sidney, MTS/N 18504424 N761AGChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21062097 N761AKHub Properties Ltd · Wilmington, DEBuilt 1977 · S/N 21062100 N761ALPacific Valley Aviation Inc · Arbuckle, CABuilt 1977 · S/N 21062101 N761AMGood Enuf LLC · Wilmington, DEBuilt 1977 · S/N 21062102 N761ANWinger Cattle Company Inc · Johnson, KSBuilt 1977 · S/N 21062103 N761AQOrangesocks Aviation LLC · Chesterland, OHBuilt 1977 · S/N 21062105 N761BDRockwell Richard E · Aledo, TXBuilt 1977 · S/N 21062118 N761BEAnderson Kristian L · Albuquerque, NMBuilt 1981 · S/N P21000660 N761BLLong Ernest D · Trabuco Canyon, CABuilt 1977 · S/N 21062125 N761BVN761bv LLC · Sioux Falls, SDBuilt 1977 · S/N 21062134 N761BYB&E Leasing LLC · Dubuque, IABuilt 1977 · S/N 21062137 N761BZAltair Aircraft LLC · Gainesville, FLBuilt 1977 · S/N 21062138

Back to AD 87-20-03 R2