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.

N240AFColumbia Av8ors Inc · Dover, DEBuilt 2005 · S/N 41525 N240BRFleetworks Inc · Santa Fe Springs, CABuilt 2015 · S/N T24002085 N240CAN240ca LLC · Wilmington, DEBuilt 2010 · S/N 411159 N240CDBlevins Douglas M · Canton, TXBuilt 2026 · S/N 11248 N240CVMooney International Corporation Inc · Kerrville, TXBuilt 2015 · S/N 33-0001 N240DEinstein Inc · Price, UTBuilt 2013 · S/N T24002023 N240DJFast Flight Sales And Leasing LLC · Benton, KYBuilt 2013 · S/N T24002021 N240DWCrenshaw Leasing IV LLC · Lancaster, SCBuilt 2014 · S/N T24002041 N240ESSchmidlin Eric · Dublin, OHBuilt 2007 · S/N L2K237 N240GBSchumaker Joseph W Jr · Petersburg, MIBuilt 1966 · S/N 310K0188 N240GGSleipnir LLC · Seattle, WABuilt 2015 · S/N T24002063 N240HCBlodgett James R · Walnut Creek, CABuilt 1979 · S/N TJ-221 N240LFNeal Thomas M · Destin, FLBuilt 2013 · S/N T24002020 N240LMChamblis John L · Webb, MSBuilt 1966 · S/N 18257601 N240MBail Air LLC · Port Saint Lucie, FLBuilt 1970 · S/N D-9211 N240MBFlying Brick LLC · Monroe, NCBuilt 2006 · S/N 1880 N240MHCwd Of Hicksville Inc · Hicksville, NYBuilt 2013 · S/N T24002035 N240MMFlood Specialists Group Inc · Des Plaines, ILBuilt 1960 · S/N 57168 N240MSQuagliano Micheal Drew · Wellington, FLFirst renewal noticeBuilt 2016 · S/N T24002120 N240MTJdi N240mt LLC · Mesa, AZBuilt 2014 · S/N T24002050 N240PCMincey Gregory Julian · Pinehurst, NCBuilt 2013 · S/N T24002016 N240RWestex Telco LLC · Abilene, TXS/N 3449496 N240RATop Aircraft Leasing LLC · Wilmington, DES/N 310Q0108 N240RCIntegrity Sales And Auction LLC · Merrill, WIBuilt 1980 · S/N 310R-1869 N240SShook Wayland R · Ocala, FLBuilt 2013 · S/N 001 N240SQMigster LLC · Miami, FLBuilt 1975 · S/N 310R0273 N240SRMontana Aircraft Trust Inc Trustee · Bozeman, MTS/N 2411 N240TAStm Consulting LLC · Lafayette, LABuilt 2017 · S/N T24002127 N240TMPaul Brightwell Dirt Works Inc · Springer, OKBuilt 2013 · S/N T24002003 N240TTRosema Keith David · Winthrop, WABuilt 2015 · S/N T24002074 N240TXIntrepid Aviation Inc · Bartow, FLBuilt 2015 · S/N T24002060 N240VBRubin H Saavedra Md Ltd · Las Vegas, NVBuilt 2015 · S/N T24002095 N240WARight Traffic LLC · Ellenton, FLBuilt 2013 · S/N 3940 N2410CChasin Tails Inc · Gouldsboro, MEBuilt 1954 · S/N 30710 N2410QRegistered aircraftBuilt 1966 · S/N 18257610 N2410XKitsap Aviation Squadron · Southworth, WABuilt 1965 · S/N 18256310 N2411RLowery Jerry W · Cartersville, GABuilt 1964 · S/N 18255511 N2412CRigid Oilfield Services LLC · El Reno, OKS/N 30712 N2412MChristensen Broadcast Group Inc · Watertown, SDBuilt 1977 · S/N 28R-7803127 N2412QTickemyer David K · Warrensburg, MOBuilt 1966 · S/N 18257612 N24131Hicks Chad A · Dalhart, TXBuilt 1978 · S/N D-10117 N24136Tj Air Holding Inc Trustee · Wilmington, DEBuilt 1978 · S/N E-1233 N2413RMachamer John K · Gettysburg, PABuilt 1962 · S/N NAV-4-2413 N2413SQualitair LLC Trustee · MichelstadtBuilt 1967 · S/N 337-0713 N24159Power Alan T · Los Alamos, NMBuilt 1982 · S/N 18504346 N2415FTrutschel Steven R · Waynesville, OHBuilt 1965 · S/N 18051615 N2415QPagel David R · Tioga, NDBuilt 1966 · S/N 18257615 N2415RRegistered aircraftBuilt 1964 · S/N 18255515 N2415TWeaver George T · Fairbanks, AKBuilt 1962 · S/N NAV-4-2415 N24161Diamond Scenery LLC · Red Oak, TXBuilt 1978 · S/N D-10103

Back to AD 2000-23-21