Skip to content

Registered aircraft · 6,349

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

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 N757LGMamet Oren · Andover, MABuilt 1977 · S/N 15279820 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 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 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 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 N757RLRudak Phillip Richard · East Hartford, 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 N757RTEnright Darren R · Lakeville, MNBuilt 1977 · S/N 15279950 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 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 N757TLSky Candy LLC · Scottsdale, AZBuilt 1977 · S/N 15279991 N757TMMayeur Terri-Jo · Wasilla, AKBuilt 1950 · S/N 18-336 N757TVTri County Rentals And Sales Inc · Lake City, FLBuilt 1977 · S/N 15280000 N757UDDau Anuar · Colfax, NCBuilt 1977 · S/N 15280007 N757UFAviation Capital Management LLC · San Jose, CABuilt 1977 · S/N 15280009 N757URRichmor Aviation Inc · Hudson, NYBuilt 1977 · S/N 15280018 N757UTIfly LLC · Wichita, KSBuilt 1977 · S/N 15280020 N757UZCoulliette Brian K · Jacksonville, FLBuilt 1977 · S/N 15280026 N757VAStoup Lyndal K · Cordell, OKS/N 15280027 N757VBGanesh Prabhandhakavi · Cerritos, CABuilt 1977 · S/N 15280028 N757VWHeckert Dale L · Nikiski, AKBuilt 1977 · S/N 15280047 N757XGJohnson Shawn A · Joliet, MTBuilt 1977 · S/N 15280081 N757XHSteinhauser Raymond P · Ashland, OHBuilt 1977 · S/N 15280082

Back to AD 80-25-02 R2