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.

N441NAHendry Rickey W · Apple Springs, TXBuilt 1955 · S/N 32198 N441SRG I C Natural Resources LLC · Columbia, KYBuilt 2006 · S/N 1704 N441TJRylee LLC · Lawrence, KSBuilt 1979 · S/N 18267141 N441TPUnited Contractors Inc · Costa Mesa, CABuilt 1978 · S/N 414A0057 N441TTSunbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0441 N441WCMoore Jeremy Emmett · Baton Rouge, LABuilt 1978 · S/N TC-2181 N441WPAero Holdings LLC · Williamston, SCBuilt 2026 · S/N 11413 N441WW4kd Corporation · Wilmington, DEBuilt 1975 · S/N CE-606 N4421RJ & B Aircraft Leasing LLC · Lufkin, TXBuilt 1985 · S/N 46-8508051 N4421UClaypool James W · Hunts Point, WABuilt 1980 · S/N 18267449 N4422NValiair Lc Trustee · Casper, WYBuilt 1978 · S/N P21000099 N4425BRadle Alexander P · Flower Mound, TXBuilt 1962 · S/N CD448 N4427WRockwall LLC · Wye Mills, MDBuilt 1974 · S/N D-9605 N4428CPayne Jeffrey C Trustee · Stockton, CABuilt 1980 · S/N EA-59 N4429LShingebiss LLC · Independence, ORBuilt 1982 · S/N 21064647 N442AKKelly Aviation Inc · Tampa, FLBuilt 1977 · S/N 310R0984 N442CCRaymond Andrew A · Crescent, IAS/N 414A0483 N442EGGrotech Inc · Fresno, CABuilt 2018 · S/N 1716 N442FMHogan Quinn H Trustee · Milwaukee, WIBuilt 1979 · S/N 414A0303 N442GBas Part Sales LLC · Greeley, COBuilt 1977 · S/N 28R-7703208 N442GMLancaster Aviation LLC · Chicago, ILS/N 2257 N442GRAk Air Leasing LLC · Homer, AKBuilt 1972 · S/N U20601811 N442LHSkylane 182q LLC · Punta Gorda, FLBuilt 1980 · S/N 18267692 N442PTAutodealersonly.Com Inc · Brunswick, GABuilt 1999 · S/N 30-0018 N442RAKing Air Properties LLC · Huntington Beach, CABuilt 1971 · S/N 18260739 N442RGRivas Andrew · Flagstaff, AZBuilt 1990 · S/N CE-1437 N442RWRobertson David · Cullman, ALS/N TE-885 N442SJRegistered aircraftBuilt 2006 · S/N 42521 N442SSN442ss LLC · Middletown, OHBuilt 1965 · S/N P206-0121 N442TAN6105s LLC · Norwood, NCS/N 41532 N442TTQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1012 N44309Urstadt Chris M · Girdwood, AKBuilt 1978 · S/N 18503486 N4430KLivingston Peter J · Ventura, CABuilt 1948 · S/N NAV-4-1430 N4430WMagerit Aviation Inc · South Boston, MABuilt 1974 · S/N D-9609 N4430XIsland Piper LLC · Portland, ORBuilt 1975 · S/N 34-7670041 N4431WUnited Roofing Of Central Florida Inc · Ocala, FLBuilt 1974 · S/N D-9606 N4432ABrown David L · Gold Hill, NCBuilt 1970 · S/N D-9144 N4432YFraiman Douglas E · Homer, AKBuilt 1979 · S/N E-1614 N4433RWtf Partnership · Anchorage, AKBuilt 1976 · S/N 18502953 N4433WLeiseth Bruce R · Merritt Island, FLBuilt 1974 · S/N TC-1671 N4434WP Scarlett Inc · Plattsmouth, NEBuilt 1975 · S/N E-742 N4435PRbr Investments Aviation LLC · Stanley, IDBuilt 2023 · S/N 9629 N4435VMacdonald Glenn · Sugar Land, TXFirst renewal noticeBuilt 1979 · S/N D-10225 N4439QLipan Creek Flying Serice LLC · Eola, TXBuilt 1971 · S/N 18800839 N443AKBark Aviation LLC · Las Vegas, NVBuilt 2024 · S/N 10344 N443CPBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3296 N443CSTextron Aviation Inc · Wichita, KSBuilt 2016 · S/N T24002110 N443LTValiair Ltd Co Trustee · Casper, WYBuilt 1976 · S/N 310R-0627 N443PFrederick Investment Corp · Raleigh, NCBuilt 1999 · S/N TH-1914 N443PGCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11657

Back to AD 2000-23-21