Registered aircraft · 81,728

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

N243RVDippel James W · Chandler, TXBuilt 2015 · S/N 11467 N243SMc Gavock Edward · Columbus, WIBuilt 1961 · S/N 1 N243SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N 22-8376 N243SDRegistration Pending · Brookings, SDRegistration pendingBuilt 2024 · S/N 4496576 N243SPBarbers Point Flight School LLC · Kapolei, HIBuilt 1999 · S/N 172S8212 N243SWWells Paul L · Whitefish, MTFirst renewal noticeBuilt 1999 · S/N 001SW N243THillestad Darrell · Aberdeen, SDBuilt 1953 · S/N 18-2357 N243TJJones Helicopters LLC · Villa Rica, GABuilt 2004 · S/N 10239 N243WMoore William · Dalhart, TXBuilt 1971 · S/N 17260205 N243XWilliamson Lee E · Franklin, KYS/N 160 N243XJLoiacono Vincent · Sunfield, MIBuilt 1965 · S/N 28-2095 N243YShilt Jerry C · El Dorado Springs, MOBuilt 2005 · S/N 3288 N244004 One Air LLC · Holland, MIBuilt 1977 · S/N 15280253 N24403Somboonsap Patanapong · Oakland Park, FLBuilt 1977 · S/N 15280254 N2440CHeaton Thomas Caleb · Princeton, KYS/N 38-79A0187 N2440DXing Kong Aviation Service LLC · Atwater, CAS/N 4496305 N2440QTeanaway Ventures Consulting LLC · Cle Elum, WABuilt 2001 · S/N 18280937 N2440TEngler William O · Filion, MIBuilt 1978 · S/N 38-78A0803 N2441AKnowles Warren R · Ocean City, NJBuilt 1978 · S/N 38-78A0691 N2441DKsm Aviation Inc · Wilmington, DEBuilt 2000 · S/N 17280983 N2441EMyf Holdings LLC · San Diego, CABuilt 2000 · S/N 17280879 N2441XPippy LLC · Naples, FLBuilt 2006 · S/N 18281802 N24429Pniak Robert J · Carmel Valley, CABuilt 2000 · S/N 18280700 N2442EExecutive Flyers Inc · Sacramento, CABuilt 1978 · S/N 17271285 N2442FZeien Robert A · Charlton, MAS/N 38-79A0444 N2442MRegistration Pending · Sterling, AKRegistration pendingBuilt 1947 · S/N 12-1545 N2442QCoastal Business Systems Inc · Eureka, CABuilt 2001 · S/N 18280938 N2442VBarts Flying Service Inc · Storm Lake, IABuilt 1980 · S/N 36-8060017 N2443AGauthier Evans J · Mckinney, TXBuilt 1953 · S/N 22-1096 N2443FAnywhere Atp LLC · Mt Juliet, TNBuilt 1979 · S/N 38-79A0445 N2443HSilver Star Jet LLC · Delafield, WIBuilt 2000 · S/N 18280702 N24440Stikes Aviation LLC · Griffin, GABuilt 2001 · S/N 18280956 N24447Mustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10122 N2444AHoward Nathan L · Fairbanks, AKBuilt 1952 · S/N 18-1939 N2444HChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280874 N2444JDavis Bret R · Boynton Beach, FLBuilt 1979 · S/N 18-7909124 N2444MMerillat Anthony J · Adrian, MIBuilt 1947 · S/N 12-1682 N2444PMcgowan Robert A · Burgaw, NCS/N 22-2815 N24450Haley David A · Whitethorn, CABuilt 2004 · S/N 001 N2445AMcmillian Dean R · Wasilla, AKBuilt 1952 · S/N 18-1940 N2445DN5511f LLC · Voorhees, NJBuilt 1978 · S/N 38-79A0319 N2445JBuzzard Aviation Inc · Freer, TXBuilt 2000 · S/N 20608095 N2445PBolivar Flyers Inc · Brighton, MOBuilt 1955 · S/N 22-2816 N2445RVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281720 N2445TBurwell Jacqueline D · Potwin, KSBuilt 1978 · S/N 38-78A0804 N2445VN2445v Cessna Inc Trustee · Wilmington, DEBuilt 2000 · S/N 18280699 N2446ASkybound Aviation LLC · Bixby, OKBuilt 2000 · S/N 18280695 N2446MCondor Aviation LLC · Bethlehem, PABuilt 1947 · S/N 12-1672 N2446NPilot'S Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1979 · S/N 38-79A0847 N2446REdgon Inc · Orlando, FLS/N 18280697

Back to AD 81-18-04 R2