Registered aircraft · 47,138

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.

N210BXNova Aircraft Holdings Inc · San Diego, CABuilt 1972 · S/N 21059583 N210CJettech Holdings LLC · Broomfield, COBuilt 1979 · S/N P21000218 N210CAPennmark Air LLC · Plymouth Meeting, PABuilt 2023 · S/N 9466 N210CBCampbell Terry G Trustee · San Francisco, CABuilt 2025 · S/N 10411 N210CCMuller Rodolfo · Kerrville, TXBuilt 1978 · S/N 21063008 N210CEMaas Aviation LLC · Pewaukee, WIBuilt 1980 · S/N P21000563 N210CFQuest Aviation Inc · Lake City, FLBuilt 1978 · S/N 21063124 N210CHOne Up LLC · Stuttgart, ARBuilt 1974 · S/N 21060142 N210CKFann Robert P · Birmingham, ALBuilt 2003 · S/N L2K-148 N210CPToeppen Chris P · Atherton, CABuilt 1979 · S/N P21000230 N210CUTcl Fbo LLC · Tuscaloosa, ALBuilt 1981 · S/N 21064452 N210CWBeach Partnership LLC · Myrtle Beach, SCBuilt 1979 · S/N 21063595 N210CX210 Equipment LLC · Lexington, SCBuilt 1972 · S/N 210-59719 N210DAStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N TH-1067 N210DCRrr Land & Cattle Co LLC · Midland, TXBuilt 1973 · S/N 21060159 N210DDDwoskin David F Trustee · San Pedro, CABuilt 1976 · S/N 21061464 N210DFHampton Harvey E · Simms, MTBuilt 1968 · S/N T210-0397 N210DGWashburn Stig K · Westminster, MABuilt 1972 · S/N 21059559 N210DLDaneco LLC · Houma, LABuilt 1978 · S/N P21000114 N210DRRaid Air LLC · Grand Rapids, MNBuilt 1978 · S/N 21063011 N210DSSevel Garry S · Fresno, CABuilt 1981 · S/N 21064275 N210DWBlomberg Nicholas R · Macon, MOBuilt 1967 · S/N 21058876 N210EBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058365 N210EAFollis Allen J · San Tan Valley, AZFirst renewal noticeBuilt 1962 · S/N 21057973 N210EBBuell Jack A · St Maries, IDBuilt 1978 · S/N 21062568 N210EFDespain Aviation LLC · Pendleton, ORBuilt 1979 · S/N P21000391 N210EGCenturion Aviation LLC · Nokesville, VAS/N 21059133 N210ETVroom Consulting Inc · Ithaca, NYFirst renewal noticeBuilt 1968 · S/N 21059079 N210FBBongard Frederic S · Torrance, CABuilt 1974 · S/N 21060441 N210FGGlover Properties LLC · Mount Pleasant, TXBuilt 1977 · S/N 21062096 N210FMAero M Inc · Key West, FLBuilt 1979 · S/N P21000259 N210FVAvoyelles Rental Corp · Bunkie, LABuilt 1980 · S/N P21000572 N210GClear Prop LLC · Kalispell, MTBuilt 2013 · S/N 2204 N210GGWiegler Michael · Austin, TXBuilt 1966 · S/N 21058790 N210GNJackson Flying LLC · Siloam Springs, ARBuilt 1961 · S/N 21057803 N210GSRetail Online Solutions Inc · Columbus, OHBuilt 1976 · S/N 21061283 N210GTTeufel Gregory W · Lake Stevens, WABuilt 1961 · S/N 21057590 N210GUTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1978 · S/N P21000067 N210HFrey Farm LLC · Fallon, NVBuilt 1986 · S/N 21064951 N210HGBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000569 N210HKConway Jenna Marie Wells · Camarillo, CABuilt 1977 · S/N R1722481 N210HPFancy Flyers LLC · Fort Worth, TXBuilt 1977 · S/N 21061829 N210JRowdy Mcbride Hunting Services LLC · Alpine, TXBuilt 1968 · S/N 21059076 N210JDCovarrubias Javier Diaz · Rancho Viejo, TXBuilt 1977 · S/N 21062169 N210JEKoch Henry Thomas · Tampa, FLBuilt 2016 · S/N 4323 N210JHSchultz Wayne T · Madras, ORBuilt 1977 · S/N 21061832 N210JKTebow William M · Bunkie, LABuilt 1977 · S/N 21061901 N210JMMustang Sally Aviation LLC · Camden, SCBuilt 1981 · S/N 21064159 N210JPCsa Aviation LLC · Leonardtown, MDBuilt 1980 · S/N P21000630 N210JRSouthard Robert W · Elk City, OKBuilt 1959 · S/N 57017

Back to AD 2000-23-21