Skip to content

Registered aircraft · 40,472

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-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N380RBShea Michael P · Nashua, NHBuilt 1987 · S/N 380 N380UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 4496211 N381Deal Mark A · Spartanburg, SCBuilt 1978 · S/N 3072 N3810MSurgical Innovations Inc · Suwanee, GABuilt 1978 · S/N 28-7816378 N3811KHendrickson Raymond G · Severn, MDBuilt 1967 · S/N 28-23737 N38120Hudson Wilburn Joel · Rocky Face, GABuilt 1977 · S/N 28-7790520 N3812CChristiansen Aviation LLC · Wilmington, DES/N ME-390 N38146Olson Richard H Trustee · Walla Walla, WAS/N 28-7790241 N38147St Denis Robert G · Lake City, FLBuilt 1977 · S/N 28-7725251 N3814PJasinski Jack J · Necedah, WIS/N 22-3504 N3814RCarlton Kevin · Mount Vernon, WABuilt 1970 · S/N 28-5835 N3814VCert Works LLC · Bennett, COBuilt 1977 · S/N R1722264 N3816PJohnson Dale M · Seminole, TXBuilt 1955 · S/N 22-3506 N3816QGoli Aviation LLC · Raleigh, NCBuilt 1971 · S/N 17259916 N3816ZBouchard Timothy D · Valdez, AKBuilt 1961 · S/N 18-7554 N38177Archer Enterprises Corp · Ossining, NYBuilt 1977 · S/N 28-7790526 N38178Gcs Aero LLC · Laramie, WYBuilt 1977 · S/N 28-7790527 N3817PCoslor Donald D Jr · Grand Island, NEBuilt 1955 · S/N 22-3507 N3817QMoses Aviation Services LLC · Uvalde, TXS/N 17259917 N3817ZLivermont Joann M · Dillingham, AKS/N 18-7555 N3818QRanch Hand Flying Club Inc · Gardiner, NYBuilt 1972 · S/N 17259918 N38190Classic Aviation Inc · Pella, IABuilt 1977 · S/N 28-7725260 N38195Inspiration Aviation Ministries · Waterville, MEBuilt 1977 · S/N 28-7716230 N38197Anderson Loran · Cooperstown, NDBuilt 1977 · S/N 28-7716231 N3819PLucas Lester L · Napa, CAS/N 22-3509 N3819QGulf Coast Aero Club Inc · Sarasota, FLBuilt 1971 · S/N 17259919 N381CAOltman Neil R · Sandia Park, NMBuilt 2004 · S/N 1368-2004 N381CC182 Flight Corp · Bronx, NYBuilt 2001 · S/N 9936CC N381DFSouth & Silver Aviation LLC · Pikesville, MDBuilt 1977 · S/N 17269718 N381FCBrown Shane · Ozark, MOBuilt 1976 · S/N 28-7615197 N381JUS Aviation Group LLC · Denton, TXBuilt 1980 · S/N 17274183 N381LJBlue Rudder Aviatoin LLC · Excelsior, MNBuilt 2002 · S/N 2843540 N381MAKnight Wings LLC · Matthews, NCBuilt 2005 · S/N 1397-2005 N381MBStrobridge Mark D · Bunnell, FLBuilt 1981 · S/N 17275303 N381MGMissionary Air Group Inc · Burlington, NCBuilt 1975 · S/N 17265873 N381WGGoodman Bob · Opelika, ALBuilt 2003 · S/N 81657 N3820RAnagnos Nick C · East Moline, ILS/N 28-5836 N3820ZBudd Kirkland G · Rushville, NES/N 18-7560 N38211Watford Aeroservice LLC · Watford City, NDBuilt 1977 · S/N 28-7716232 N38214Mora Steven T · Corning, CABuilt 1977 · S/N 28-7790530 N3821KSoar Above Flight Solutions LLC · Englewood, TNBuilt 1967 · S/N 28-23739 N3821PRadach Kenneth D · Copper Center, AKBuilt 1955 · S/N 22-3511 N3822QMatanane Roke C · Barrigada, GUBuilt 1971 · S/N 17259922 N3823ZFranks Cory B · Idalou, TXBuilt 1960 · S/N 18-7563 N38248Plane Training LLC · Rapid City, SDBuilt 1977 · S/N 28-7716234 N3824MDraveling Larry J · Wasilla, AKFirst renewal noticeBuilt 1947 · S/N 12-2744 N3824RAbove All Aviation Inc · Santa Barbara, CABuilt 1980 · S/N MC-741 N3824ZMoore Ricky J · Milton, KYBuilt 1980 · S/N MC-644 N38250Elkins John H · Lancaster, MABuilt 1977 · S/N 28-7790531 N38254Syracuse Flying Club Inc · Fayetteville, NYBuilt 1977 · S/N 28-7790534

Back to AD 80-04-03 R2