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.

N443RSalinas Construction Technologies Ltd · Pleasanton, TXS/N 414-0361 N4440BHaustrom Curtis R · Barnesville, OHS/N 73-30614 N4440KKate & Jennifer Airlines LLC · Tampa, FLBuilt 1974 · S/N 421B0567 N4440RLa Baronesa LLC · Fort Worth, TXS/N TC-1072 N4441QHaring Clay DBA · Lincoln, KSBuilt 1971 · S/N 18800841 N4441VKilo Tango 716 LLC · Carlisle, PABuilt 2018 · S/N 1758 N4441WHodge Henry D Jr · Anchorage, AKBuilt 1978 · S/N U20604389 N4441XKaschak Tom · Stateline, NVBuilt 1975 · S/N 34-7670043 N44431Cushman Nicholas R · Mesa, AZBuilt 1951 · S/N 22598 N4443FGood Winds LLC · Waterville, MEBuilt 1951 · S/N 22085 N4443KClarke Richard W · Royal Oak, MDBuilt 1948 · S/N NAV-4-1443 N4443PRealtime Consulting LLC · Winter Park, FLBuilt 1951 · S/N 23079 N4443RCold Region Air LLC · Fairbanks, AKBuilt 1976 · S/N 18502957 N44441Breeden William N · Gaithersburg, MDBuilt 1966 · S/N 18258015 N4444KSivyllis Costas · Port Orange, FLFirst renewal noticeBuilt 1964 · S/N D-7422 N4444TKinzie Industries LLC · Alva, OKBuilt 1966 · S/N P206-0290 N4444WKoehler Robert E · West Lafayette, INBuilt 1961 · S/N 18253371 N4446Bauermeister Aida · Ham Richmond SurrBuilt 2007 · S/N 41756 N44463Sabine Financial Services Inc · Wilmington, DEBuilt 1988 · S/N 4608113 N4446XRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1975 · S/N 34-7670044 N4448RBell F Robert · Anchorage, AKBuilt 1976 · S/N 18502960 N4449GHuntley John · Bellingham, WABuilt 1962 · S/N 21058087 N4449SMccutchen John J II · Houston, TXBuilt 1975 · S/N TC-1873 N4449WJameson Clarke Enterprises LLC · Houston, TXBuilt 1974 · S/N TH-451 N4449XBurns William R · Greensboro, GABuilt 1962 · S/N 18254138 N4449YTx Waste Ventures LLC · Caddo Mills, TXBuilt 1975 · S/N E-657 N444AASipola Don H · Virginia, MNBuilt 1973 · S/N 18261920 N444AFContinental Aero Associates Inc · Grosse Pointe Park, MIBuilt 1974 · S/N D-9590 N444AHPhalanx Pc LLC · Austin, TXBuilt 2006 · S/N 2137 N444ANJmr Air LLC · Spokane, WABuilt 2015 · S/N 1154 N444BDAddington James T · Denton, TXBuilt 1960 · S/N 94629 N444BJLelouis Michael P · Sacramento, CABuilt 1962 · S/N D-7023 N444BRNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 310H0062 N444BSSiemens Christopher L · Seminole, TXBuilt 1978 · S/N 21062823 N444BZWilliams Allen G Jr · Fort Worth, TXBuilt 1974 · S/N 414-0490 N444CCVon Almen James Martin · Lewisburg, TNBuilt 1979 · S/N CE-845 N444CHSouthport Aviation Inc · Hephzibah, GAS/N TC-1736 N444CLK G L Aviation Inc · Villisca, IABuilt 1975 · S/N 21060910 N444CVCloud Punchers LLC · Cary, NCBuilt 2017 · S/N 4527 N444DGSwanson Douglas A · Marana, AZS/N D-9882 N444DMGosnell Josh W · Richards, TXBuilt 1974 · S/N 414-0522 N444DTBagdasarian Walter DBA · El Cajon, CAS/N 4608008 N444DWTriple 4 Dw LLC · Davie, FLBuilt 1972 · S/N D-9416 N444ECOvation LLC · Wichita, KSBuilt 2006 · S/N 29-0467 N444FRegistration Pending · Auburn, CARegistration pendingBuilt 1977 · S/N 21061686 N444FCCentric It Resources LLC · Loomis, CABuilt 1981 · S/N EA-257 N444GCCampbell Gregory A · Davis, ILBuilt 2005 · S/N ES-176 N444GENeverland LLC · Emerson, IABuilt 1978 · S/N 18266675 N444GNLandeis Keith · Mandan, NDBuilt 2015 · S/N 31-0139 N444HKChurch David H · Albuquerque, NMBuilt 2003 · S/N 29-0312

Back to AD 2000-23-21