Registered aircraft · 47,133

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N3862RToco Inc · Healdsburg, CABuilt 1981 · S/N EA-217 N38636Fre Investments LLC · Enterprise, ALBuilt 1977 · S/N 28R-7703253 N38639Mccullough Peter Lee · Doylestown, PABuilt 1977 · S/N 28R-7703255 N3863DDulley Tony A · Nine Mile Falls, WABuilt 1957 · S/N 34563 N3864CPearce Robert W · Santa Fe, NMBuilt 1981 · S/N E-1846 N3864UInterrail Power Inc · Jacksonville, FLBuilt 1981 · S/N TJ-355 N38650Sciorrotta Samuel C Jr · Gainesville, GABuilt 1981 · S/N E-1845 N38664Aerostyles LLC · Colorado Springs, COS/N 28R-7703259 N3866ARare Aircraft Ltd · Faribault, MNBuilt 1969 · S/N CD-1236 N3866CProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 31014 N3866YMessina Jacob · Copley, OHBuilt 1964 · S/N 21058366 N38679Bwt Aviation LLC · Montgomery, ALBuilt 1977 · S/N 34-7770332 N3867CKrmo Aviation LLC · Duluth, MNFirst renewal noticeBuilt 1954 · S/N 31015 N3867DPrestige Air Worldwide LLC · Seneca, SCBuilt 1957 · S/N 34567 N3867GW & S Aviation LLC · Fountain Inn, SCBuilt 1981 · S/N TH-1251 N3867YGallagher Robert B · Rio Oso, CABuilt 1964 · S/N 21058367 N3868DRegistered aircraftBuilt 1957 · S/N 34568 N3868QLibbys Sporting Camps Inc · Chapman, MEBuilt 1973 · S/N 18502205 N3868URegistered aircraftBuilt 1981 · S/N D-10372 N3868YTalewinds LLC · Litchfield Park, AZBuilt 1981 · S/N E-1852 N3869DOwens Hay LLC · Crane, ORBuilt 1957 · S/N 34569 N3869SPeterson Kurtley D · Gunnison, UTBuilt 1981 · S/N EA-223 N3869YMak Air Ventures LLC · Smithfield, NCBuilt 1981 · S/N TC-2388 N386AMAdvocate Air LLC · North Logan, UTBuilt 2014 · S/N 0823 N386BCSky Is The Limit LLC · Wichita, KSBuilt 1979 · S/N 0077 N386CKRiggs Russell · Sedalia, COBuilt 2009 · S/N 3473 N386DEDestinations Efc LLC · Tulsa, OKBuilt 2024 · S/N 9904 N386DMFantini Michael A · Sayre, PABuilt 2011 · S/N L2K-286 N386GTab Holdings LLC · Fort Dodge, IABuilt 2015 · S/N 1053 N386ROglesby Kevin · Fairfield Township, OHBuilt 1961 · S/N CD-386 N386RRProspective Management LLC · Ann Arbor, MIBuilt 2006 · S/N 2262 N386VHGrowthland Ag Realty Inc · Humboldt, IABuilt 1972 · S/N CE-386 N38701Sefton James Patrick · Carolina Beach, NCBuilt 1977 · S/N 28R-7703260 N38703Ollieboy Productions LLC · Kalispell, MTBuilt 1977 · S/N 28R-7703261 N3870DKlad-Air LLC · Catlett, VABuilt 1957 · S/N 34570 N3870VMercury International LLC · Cheyenne, WYBuilt 1977 · S/N R1722266 N38720Arrow N38720 LLC · West Des Moines, IABuilt 1977 · S/N 28R-7703264 N3872W6 Chicks Aviation LLC · Santa Maria, CABuilt 1981 · S/N EA-225 N3873BNpa Baron LLC · Gladewater, TXBuilt 1981 · S/N TH-1255 N3873GKronfuss Edward P · Bozeman, MTBuilt 1967 · S/N U206-0873 N3873MMorris Air LLC · Hopkinsville, KYBuilt 1978 · S/N 28R-7803198 N38741Hoyda Jeffrey A · Tiffin, OHBuilt 1977 · S/N 28R-7703267 N3874GMcfarlane Bradley J · Port Alsworth, AKS/N U206-0874 N3874YDavenport Henry B III · Charles Town, WVBuilt 1981 · S/N TH-1256 N38750Mike Mcfadden Enterprises Inc · Laurel, MDBuilt 1977 · S/N 34-7770336 N3875DJames D Wirt · Goldsby, OKBuilt 1957 · S/N 34575 N3875UCody Plane Corp · Wilmington, DEBuilt 1964 · S/N 336-0175 N38768Ovajet Group Inc · Miami, FLBuilt 1977 · S/N 34-7770085 N3876DBurns William Greg · Eloy, AZBuilt 1958 · S/N 34839 N3876VKramer William L · Big Lake, AKBuilt 1981 · S/N 18504167

Back to AD 2000-23-21