Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

N777JYKingslyn Ltd · Wilmington, DEBuilt 1978 · S/N 31-7912004 N777MEDe La Garza De La Fuente Jose A · Montgomery, TXBuilt 1980 · S/N 31-8012049 N777RZRapid 6 Flyers LLC · Rapid City, SDBuilt 1970 · S/N 32-40907 N777SCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 31-596 N777VZFreeman Brooks · Richmond, VABuilt 1981 · S/N 31-8212012 N777WLucky Shot LLC · Dayton, OHBuilt 1977 · S/N 32R-7780297 N777XTBeach Travis W · Bishop, CABuilt 2005 · S/N 1-B N777YUEvenhaim Ronen · Canoga Park, CABuilt 1980 · S/N 32R-8029065 N777ZMFriar Aerospace Group LLC · Dover, DEBuilt 1980 · S/N 31-8052193 N7783VWarhol Peter J · Peever, SDBuilt 1970 · S/N 1536 N778EJobin Lyle · Saint Augustine, FLS/N 61P-0434-161 N7799VCb Aerial Application LLC · Kirksville, MOBuilt 1970 · S/N 1552 N779MRRock N Robins Flying Service LLC · Palm City, FLBuilt 1976 · S/N 27-7654047 N77AJGreen Nicholas S · Lakeland, TNBuilt 1976 · S/N 32R-7680371 N77DSBalderas Alberto · Harlingen, TXS/N 317812061 N77DUChaffee Merilyn D · Angwin, CABuilt 1999 · S/N 3257101 N77DXWolfert Jonathan M · Dallas, TXBuilt 1998 · S/N 27-0253 N77EWBellanca Aviation Of Blairstown LLC · Andover, NJBuilt 1974 · S/N 74-32-137 N77RHFelty Johnathon T Sr · Auburn, PABuilt 1974 · S/N 32-7440103 N77SBYanta Chris J · Rockport, TXBuilt 1977 · S/N 32-7740086 N77TTTurley James H · Plainwell, MIBuilt 1976 · S/N 32R-7680244 N77YYN77yy Corp Trustee · Wilmington, DEBuilt 1999 · S/N 32-57120 N780GCAir Eye Md LLC · Carolina, PRBuilt 1978 · S/N 317812069 N781DKSpruce Ave Air LLC · Phoenix, AZBuilt 2006 · S/N T18208597 N7824TRoss Charles · Midlothian, TXBuilt 1978 · S/N 32R-7887032 N7827SStar Aviation Inc · Melville, NYBuilt 1982 · S/N 31-8252035 N782DEBoard Susan W · Moundsville, WVBuilt 1968 · S/N 31-224 N78379Bottrell John E II · Yukon, OKBuilt 1962 · S/N 500A-1265-88 N7857FGeorge William Jesse · Alamogordo, NMBuilt 1976 · S/N 32R-7780084 N785HCKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1999 · S/N 4636206 N785SASpringate Scott T · Chelan, WABuilt 2001 · S/N T18208035 N7868FC & R Aero Inc · Marco Island, FLBuilt 1976 · S/N 32R-7780085 N786MDBas Part Sales LLC · Greeley, COBuilt 1998 · S/N 4636156 N787ARLeung Ka Hung · Apple Valley, CABuilt 1980 · S/N 32R-8029083 N787HPHolt Gary L · Ventura, CABuilt 1995 · S/N 4636013 N787RKEpitrop Foundation · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1968 · S/N 1832-29 N787RWJw Venture Aviation LLC · Concord, NCS/N 31-7652087 N788CADunekacke Joel F · Elk Creek, NEBuilt 1978 · S/N 32R-7887256 N788JGJg Aviation LLC · Westport, CTBuilt 2004 · S/N 3257369 N789JNChandelle Co · Marion, IABuilt 1989 · S/N 4622056 N789TBKelly Derrell R · Truman, MNBuilt 1999 · S/N 1919 N78AARw Higginsllc · Armuchee, GABuilt 1977 · S/N 32R-7780239 N78EHN78eh Management LLC · Lewes, DEBuilt 1978 · S/N 32R-7887025 N78FLFlight Levels LLC · Ridgeland, MSBuilt 2005 · S/N 4636371 N78GBJones Richard · Cornville, AZBuilt 1978 · S/N 32R-7887282 N78GHCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 31-7852121 N78GSAir Mods And Repair Corp · Robbinsville, NJBuilt 1972 · S/N 27-4833 N78JT71793 LLC · San Luis Obispo, CABuilt 1978 · S/N 27-7854138 N78KTJbt Aviation LLC · Shawano, WIBuilt 1975 · S/N 61P-0258-049 N78MRShembekar Ajit R · Novi, MIS/N 32R-7987095

Back to AD 84-19-03 R1