Skip to content

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N757KMClover Park Technical College · Tacoma, WABuilt 1977 · S/N 15279801 N757KXDamian Davis Construction Co · Candler, NCBuilt 1977 · S/N 15279811 N757LBSwaney Brian W · Pendleton, SCBuilt 1977 · S/N 15279815 N757LELake Elmo Aero LLC · Lake Elmo, MNS/N 17266022 N757LGMamet Oren · Andover, MABuilt 1977 · S/N 15279820 N757LKNuckolls Douglas W · Lancaster, CABuilt 1979 · S/N R18201245 N757LMYeary Clifton K · Quitaque, TXBuilt 1977 · S/N 15279825 N757LNWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279826 N757LPPrice Thomas E · Ogden, UTFirst renewal noticeBuilt 1977 · S/N 15279827 N757LXSt Louis Flight Training LLC · Cahokia, ILBuilt 1977 · S/N 15279835 N757LYHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279836 N757MGOhio Gypsum Floors LLC · Westerville, OHBuilt 1977 · S/N 15279844 N757MK101 Flight LLC · Waterford, MIBuilt 1974 · S/N 17264629 N757MLSchaffer Michael W · New Meadows, IDBuilt 2013 · S/N 556-2013 N757MMDsr-Cherokee 180 LLC · Dallas, TXBuilt 1977 · S/N 15279849 N757MPAvcorp Holdings Inc · Jackson, MIBuilt 1977 · S/N 15279851 N757MSAngel Aviation Inc · Peoria, AZS/N 15279854 N757MYStaley Grady R · Liberty, NCBuilt 1977 · S/N 15279860 N757NGWeisman Craig A · Falls Of Rough, KYBuilt 1977 · S/N 15279868 N757NJSpace Coast Aircraft Co · Merritt Island, FLBuilt 1977 · S/N 15279870 N757NNCarton David M · Claremont, NHBuilt 1977 · S/N 15279874 N757NQA&R Aero LLC · Sacramento, CABuilt 1977 · S/N 15279876 N757PDLeavitt Erin G · Lewiston, IDBuilt 1979 · S/N R18201251 N757PEMoretti Luigi U Ricci · Swarthmore, PAS/N R18201252 N757PMKaiser Gavin · Peachtree City, GAS/N 15279896 N757PPFields Joseph H · Placerville, CABuilt 1977 · S/N 15279898 N757PTPavlock Russell H · Tinley Park, ILBuilt 1977 · S/N 15279902 N757PUAvs Aviation LLC · Williamsburg, VABuilt 1979 · S/N R18201253 N757QBHutchison William B · Canton, OKBuilt 1977 · S/N 15279910 N757QHWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279916 N757QJWaters Thomas J · Hampton, GABuilt 1977 · S/N 15279917 N757QQKostelecky Scott J · Decatur, TXBuilt 1977 · S/N 15279923 N757QTMoxley Equipment Co Inc · Council Grove, KSBuilt 1979 · S/N R18201258 N757RATorello Marty A · Port Huron, MIBuilt 1978 · S/N 15279933 N757RLRudak Phillip Richard · Wethersfield, CTBuilt 1977 · S/N 15279943 N757RNSky Aviation & Maintenance Inc · Wildomar, CAS/N 15279945 N757RPBoyne Valley Flyers Club Inc · Boyne Falls, MIBuilt 1977 · S/N 15279946 N757RSRegistered aircraftBuilt 1978 · S/N R18200308 N757RTEnright Darren R · Lakeville, MNBuilt 1977 · S/N 15279950 N757RYSale Reported · Corona, CASale reportedS/N R18201260 N757RZCox Derrell L · Pamplico, SCS/N 15279956 N757SCHicks Byron · Manchaca, TXBuilt 1977 · S/N 15279959 N757SDYu Hermon Lemuel C · Mays Landing, NJBuilt 1977 · S/N 15279960 N757SP4e Aviation LLC · Alpine, UTS/N R18201261 N757SQByrne Sarah Boltz · Dallas, TXBuilt 1979 · S/N R18201262 N757STChester Charter Inc · Chester, CTBuilt 1977 · S/N 15279974 N757SWSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1977 · S/N 15279977 N757TAHofmeister Laurence C · Punta Gorda, FLBuilt 1977 · S/N 15279981 N757TDNew Horizon Aviation Inc · Warwick, RIBuilt 1977 · S/N 15279984 N757THGoodrich Pilot Training Center LLC · Johnson City, NYBuilt 1977 · S/N 15279988

Back to AD 80-25-07 R1