Registered aircraft · 108,428

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N149FFountain Flying Service-Genesee LLC · Genesee, IDBuilt 2021 · S/N 5790 N149FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2017 · S/N 18283002 N149GMetro Flyers Ltd · N Richland Hills, TXBuilt 1966 · S/N D-8100 N149JCCorrea Javier Rafael · Caguas, PRS/N 17276119 N149JLKenyon Terry J · Henderson, ARBuilt 1975 · S/N 28R-7535109 N149JTPanhandle Associates Inc · Guymon, OKBuilt 1986 · S/N THOMPSON 0001 N149KCLoveless Gaylan · Elaine, ARS/N 696 N149LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13125 N149LFFord Larry M · Sebastopol, CAS/N 395 N149LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842192 N149MAOaks Aviation LLC · Clear Lake, MNBuilt 2001 · S/N 260005 N149MEMccrary Mike M · Fairhope, ALBuilt 2000 · S/N 18280721 N149PAelick Joel D · Charlotte, NCBuilt 1979 · S/N M-2237 N149PKLange Helicopters Inc · San Angelo, TXBuilt 2006 · S/N 11570 N149PRCloudbase Flyers LLC · Hillsboro, ORFirst renewal noticeBuilt 2020 · S/N 70149 N149RBest Erectors Inc · Wilmington, DEBuilt 1978 · S/N D-10161 N149RHHinton Scott A · Elizabeth City, NCBuilt 2007 · S/N 149 N149SAVan Bergen Matthew D · Arlington Heights, ILBuilt 2008 · S/N 10672008 N149SGWaterwings Seaplanes LLC · Hoover, ALBuilt 2006 · S/N 1021-2006 N149TBonilla Jose · Pembroke Pines, FLBuilt 1981 · S/N 18267896 N149TGGrandview Aerial Operations LLC · Alexander, NCS/N 3280 N149TMBoundless Action Sports LLC · Gilroy, CAS/N 5165 N149TSHawkins David B · Dallas, TXBuilt 2005 · S/N 81006 N149UDW Air LLC · Chicago, ILBuilt 2003 · S/N 17281185 N149WSWexman Scott E · Port Hadlock, WABuilt 2008 · S/N 5257 N149ZBBowman Brice R · Indianapolis, INBuilt 2020 · S/N 90620 N14ACLippert Bradley W · Crawford, COBuilt 1997 · S/N 29-0117 N14AEOsborn Jon C · Groveland, FLBuilt 2000 · S/N 30012C N14ARRatliff Alvin · Northport, ALBuilt 1975 · S/N CE-561 N14AXKokstis Mark D · Carlisle, IABuilt 1983 · S/N 001 N14AZD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1975 · S/N 17263495 N14BFeinberg Eugene M · San Jose, CAS/N DMO 157 N14BABurris & Macomber P L L C Trustee · Tucson, AZS/N 18261211 N14BEBelmont Circle LLC · Virginia Beach, VABuilt 1979 · S/N 28-7911322 N14BGAugust Aero LLC · Kalispell, MTBuilt 1970 · S/N 1 N14BLEagle Equity Inc · Valparaiso, INBuilt 1968 · S/N 17257735 N14BRGobin Albert W · Crawfordsville, INS/N 310K0104 N14BSOklahoma Warbird Aviation LLC · Oklahoma City, OKS/N 1376987 N14CBEverything Pitts LLC · Queen Creek, AZS/N 2001 N14CEFacility Concepts Developments LLC · Jackson, MSBuilt 1989 · S/N TH-1562 N14CFFairchild Carter Kent · Indiantown, FLBuilt 1991 · S/N 2661 N14CLValiair Ltd Co Trustee · Casper, WYBuilt 2003 · S/N L2K-203 N14CMGallagher Michael S · Los Alamitos, CABuilt 1971 · S/N D-9298 N14CXVortac LLC · Traverse City, MIBuilt 1988 · S/N 4608107 N14CZHollingsworth Aaron · Denver, COFirst renewal noticeS/N MK 0100 N14DADonaire Aviation LLC · Tampa, FLBuilt 1962 · S/N TD-505 N14DEAllred Mike · Thomasville, NCBuilt 1981 · S/N 1 N14DFCook Charles M · Jay, FLBuilt 1957 · S/N D-5336 N14DJJ&N Management Inc · Wilmington, DEBuilt 2001 · S/N 2843497 N14DP5b Aviation LLC · Duncan, OKBuilt 1970 · S/N 28-5738

Back to AD 2007-04-19 R1