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.

N737URSky Warrior Flight Training LLC · Pensacola, FLBuilt 1977 · S/N 17269690 N737UYFlycarolina LLC · Concord, NCBuilt 1977 · S/N 17269696 N737VAMartin Dana J · Spicewood, TXBuilt 1977 · S/N 17269698 N737VBDavis Gregory L · Williamsburg, NMS/N 17269699 N737VCN737vc LLC · Wilmington, DEBuilt 1977 · S/N 17269700 N737VERev Jet LLC · Pflugerville, TXBuilt 1977 · S/N 17269702 N737VFCompass Aviation Maintenance LLC · Shelby, NCBuilt 1977 · S/N 17269703 N737VLAuthorized Health Insurance Inc · Fair Oaks, CABuilt 1977 · S/N 17269708 N737VNRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1977 · S/N 17269710 N737VSWalters Pujadas & Walker Pc · Ocilla, GAS/N 17269714 N737VTHudson Gary L · Lake Havasu City, AZBuilt 1979 · S/N R18200886 N737VUBlog Thomas M · Santa Fe, NMBuilt 1979 · S/N R18200887 N737VVDorsey Terry R · Henderson, TXBuilt 1977 · S/N 17269717 N737VXL&G Aviation LLC · Fresno, CABuilt 1979 · S/N R18200888 N737WAFlying Taco LLC · Fountain Inn, SCBuilt 1977 · S/N 17269722 N737WCJ.R.P. Leasing Ltd · Carroll, IABuilt 1977 · S/N 17269723 N737WEWild Eagle Aviation LLC · Arvada, COBuilt 1977 · S/N 17269725 N737WFMainero Tanner R · Chehalis, WABuilt 1952 · S/N 25346 N737WNMorton Jeremy R Jr · Stamford, CTBuilt 1979 · S/N R18200891 N737WPAeroworks Productions LLC · Kenosha, WIBuilt 1970 · S/N 177RG0032 N737WQHinote Holdings LLC · Saint Charles, MOBuilt 1977 · S/N 17269734 N737WRN737wr LLC · Jacksonville, FLBuilt 1977 · S/N 17269735 N737WSBoeing Employees Flying Association · Renton, WABuilt 1978 · S/N 17269736 N737WTHillcrest Aircraft Co · Lewiston, IDBuilt 1977 · S/N 17269737 N737WV737wv LLC · New Braunfels, TXS/N R18200892 N737WXWhorton Aviation LLC · Winder, GABuilt 1977 · S/N 17269741 N737WYSportsflying Ventures LLC · Gastonia, NCS/N 17269742 N737XAFirst Eclipse Limited · Richmond, VABuilt 1977 · S/N 17269744 N737XDCraig K Dpe LLC · Kaaawa, HIBuilt 1979 · S/N R18200893 N737XEZia Sky LLC · Las Cruces, NMBuilt 1977 · S/N 17269748 N737XFCasper Holdings Inc · New Castle, DEBuilt 1977 · S/N 17269749 N737XMJ F P Inc · Ellsworth, MEBuilt 1977 · S/N 17269755 N737XSUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1977 · S/N 17269759 N737XTHeins Alfred Jr · Monticello, NYBuilt 1977 · S/N 17269760 N737XURaynor Andrew C · Kingman, AZS/N 17269761 N737XWWeiss Gregory K · Colorado Springs, COBuilt 1977 · S/N 17269763 N737XXEgan Walter G Jr · Port Orange, FLBuilt 1979 · S/N R18200894 N737XZBrown John P Jr · Winter Garden, FLBuilt 1977 · S/N 17269766 N737YADuffys Aircraft Sales And Lsg Inc · Neillsville, WIBuilt 1977 · S/N 17269767 N737YBBurke Donald T · Scranton, NDBuilt 1977 · S/N 17269768 N737YEAeroventures Flying Club Inc · Lilburn, GABuilt 1977 · S/N 17269771 N737YFVero Technical Support Inc · Pensacola, FLBuilt 1977 · S/N 17269772 N737YGAgassiz Flyers Inc · Herman, MNBuilt 1977 · S/N 17269773 N737YKKaher Ryan G · Menlo Park, CABuilt 1979 · S/N R18200895 N737YPYankee Papa LLC · Wilmington, DEBuilt 1977 · S/N 17269780 N737YQTec Aviation Inc · Pasco, WABuilt 1977 · S/N 17269781 N737YSCk Max LLC · Stanford, KYBuilt 1977 · S/N 17269783 N737YT80075 Aircraft Corporation LLC · Wilmington, DEBuilt 1973 · S/N 17261481 N737YULake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 17269785 N737YVLees Sea Air · Kiana, AKBuilt 1977 · S/N 17269786

Back to AD 87-20-03 R2