Skip to content

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.

N242RBContinental Aerospace Technologies Inc · Mobile, ALBuilt 2011 · S/N 172S11131 N242RDTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283334 N242RSPape Brandon M · Mc Gregor, TXBuilt 1997 · S/N 2054 N242RVSearle Ronald Q · Franktown, COBuilt 2025 · S/N 41676 N242SBMartin Thomas R · Roseville, MNBuilt 1989 · S/N 001 N242SP242sp LLC · Blaine, MNBuilt 1999 · S/N 172S8226 N242STOlivier Andre · River Ridge, LABuilt 2003 · S/N 3313 N242TWTw Airplane LLC · San Antonio, TXBuilt 2005 · S/N 172S9896 N242USilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608242 N242URSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 0857 N242WYHeber Huskies LLC · Salt Lake City, UTBuilt 2015 · S/N 3242 N242YAerospace Development Group Inc · Trinity, FLBuilt 2004 · S/N 40.404 N242ZMason Scott C · Lebanon, ORS/N JM-2 N24305Woolsey Joseph A · Squaw Valley, CABuilt 1977 · S/N 15280206 N2430KTylenda John R · Bigelow, ARBuilt 2005 · S/N 22712 N2430YBuckman Arnold H Trustee · Spring Valley, ILBuilt 1985 · S/N 32R-8513002 N24313Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280210 N24315Cubicle Concepts Inc · New Holland, PABuilt 1977 · S/N 15280212 N24318Milo Technologies LLC · Woodstock, GABuilt 2001 · S/N 17280994 N2431ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 22-787 N2431ESpartan College Of Aeronautics And Technology · Broomfield, COBuilt 1978 · S/N 17271280 N2431FPilot Craft Aviation LLC · Monterey, CABuilt 1979 · S/N 38-79A0437 N2431GGulf Coast Helicopters Inc · Pearland, TXBuilt 2000 · S/N 18280681 N2431MSchroeder John · Anacortes, WABuilt 1947 · S/N 12-1675 N2431QWade Consulting LLC · Aviston, ILBuilt 2000 · S/N 18280684 N2431SDavis Girls LLC · San Jose, CABuilt 1979 · S/N R18201340 N24327Centurion Aviation · Salina, KSFirst renewal noticeBuilt 1977 · S/N 15280218 N2432HErsland Ryan Peter · Anchorage, AKBuilt 1979 · S/N 18-7909184 N2432MBunce John · Canaan, CTS/N 12-1530 N2432NMastre Benjamin T · Soldotna, AKBuilt 1947 · S/N 12684 N24331Registration Pending · Norman, OKRegistration pendingBuilt 1977 · S/N 15280219 N24333Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280220 N24334Sorbi Aviation Inc · El Cajon, CABuilt 2000 · S/N 17280887 N2433ARyther John W · Austin, MNS/N 20-929 N2433EElco Electric · Bangor, MEBuilt 2000 · S/N 20608136 N2433FJohnson Paul · Newnan, GABuilt 1979 · S/N 38-79A0438 N2433MHarkey Aviation LLC · Sherrills Ford, NCBuilt 1977 · S/N 28-7816285 N2433NFalcon Aerolab LLC · Colorado Springs, COBuilt 1979 · S/N 38-79A0840 N2433SN2433s LLC · Manassas, VABuilt 2000 · S/N 17280872 N24342Loma Aviation LLC · San Diego, CABuilt 1973 · S/N 287305419 N2434MSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1977 · S/N 28-7890251 N2434YRegistration Pending · Cedar Falls, IARegistration pendingBuilt 2000 · S/N 20608078 N24350Aero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10144 N24351426th Aero Squadron LLC · Cropwell, ALBuilt 1977 · S/N 15280230 N2435CAzure Skies LLC · Bloomington, INBuilt 1999 · S/N 18280644 N2435DThibodeau Dean U · North Pole, AKBuilt 1952 · S/N 20587 N2435MBrolan Aviation LLC · Kansas City, MOBuilt 1977 · S/N 28-7890253 N2435PGarst William P · Johnson City, TNBuilt 1955 · S/N 22-2806 N24363Sale Reported · Crystal, MNSale reported, canceledBuilt 1977 · S/N 15280235 N24364Monsalve Carlos M · Lewiston, NYBuilt 1977 · S/N 15280236

Back to AD 81-18-04 R2