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.

N2371ETmc Shooting Range Specialist Inc · Valencia, CAS/N 17271254 N2371PZmirly Aviv · San Diego, CABuilt 1955 · S/N 22-2762 N2371TThomas Jacob W · Loris, SCS/N 28-7225056 N2371WSpaich Brad G · Mcpherson, KSBuilt 1966 · S/N MB-9 N2372AOquinn Timothy M · Tehachapi, CABuilt 1978 · S/N 38-78A0661 N2372CMartin Land Improvement Inc · Elk Rapids, MIBuilt 1978 · S/N R18200164 N2372JSea Serpent Tours Inc · Saint Augustine, FLS/N M-336 N2372KKremer Charles A · Mckinney, TXS/N 38-79A0597 N2372QBlack Stephen L · Winterset, IABuilt 1963 · S/N M-445 N2372SChristensen Robert F · Gillette, WYBuilt 1979 · S/N 18-7909138 N2372WHulme Aviation LLC · Gilbert, AZBuilt 1966 · S/N MB-10 N23735Leighton Farms Ltd · Griswold, IABuilt 1999 · S/N 18280458 N23738Laureano Reynaldo · Murfreesboro, TNBuilt 1979 · S/N 38-79A1049 N2373CDs Flight Services LLC · Battle Ground, WABuilt 1978 · S/N R18200165 N2373GCentral Iowa Aviation LLC · Ankeny, IABuilt 1998 · S/N 172S8073 N2373JHilker David E · Cimarron, KSBuilt 1979 · S/N 18-7909113 N2373KReading Aero Club Inc · Reading, PABuilt 1999 · S/N 172S8074 N2373MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10592 N2373TNeuharth Randall H · Norfolk, NEBuilt 1971 · S/N 28-7225003 N2373WFayettenam Aero LLC · Laurinburg, NCBuilt 1966 · S/N MA-3 N2373ZN3812q LLC · San Diego, CABuilt 1999 · S/N 172S8075 N2374CJackson Jeffrey D · Elk City, OKBuilt 1978 · S/N R18200166 N2374LFrederick Calvin · Homestead, FLBuilt 1979 · S/N 38-79A0687 N2374TFlying High Investments LLC DBA · Winnemucca, NVBuilt 1971 · S/N 28-7225017 N2374ZSale Reported · Fort Worth, TXSale reported, canceledBuilt 1962 · S/N M-98 N23756Sweet Fred A · Loves Park, ILBuilt 1998 · S/N 18280429 N2375CEverwind Aviation LLC · Kalispell, MTBuilt 1978 · S/N R18200167 N2375JBarr Air Patrol LLC · Mesquite, TXBuilt 1999 · S/N 18280451 N2375LEdgren Alan J · Punta Gorda, FLBuilt 1963 · S/N M-223 N2375MValentine Ronald F Jr · Santa Maria, CABuilt 1977 · S/N 28-7816280 N2375PKirsteatter Todd · Kewaunee, WIBuilt 1955 · S/N 22-2766 N2375QTaxes Suck LLC · Orlando, FLBuilt 1963 · S/N M-449 N2375ZMorrissett Jay Dean · Bumpass, VABuilt 1962 · S/N M-99 N2376Moore Charles D · Willow, AKBuilt 1992 · S/N 2062 N23765Rose Jeffrey C · Carmichael, CABuilt 2015 · S/N 81652 N2376JWinstead Jonathan M · Griffin, GABuilt 1963 · S/N M-339 N2376LRbg Aviation LLC · Middleburg, FLBuilt 1963 · S/N M-212 N2376MHuberd Kyle A · Wilsonville, ORBuilt 1946 · S/N 12-1504 N2376PBoyd Paul E · North Pole, AKBuilt 1955 · S/N 22-2767 N2376QEisenmann James R · Fort Worth, TXBuilt 1963 · S/N M-450 N2376RRegistered aircraftBuilt 1999 · S/N 18280431 N2376TStranberg Ray L · Bakersfield, CAS/N 28-7225057 N2376VPeyrot Eric M · Summerland Key, FLBuilt 1998 · S/N 18280432 N2376XMueller Howard W · Winston Salem, NCBuilt 1999 · S/N 18280433 N2377Young Robert L · Oakwood, ILBuilt 1970 · S/N 16408488 N2377EBeck Roger M Trustee · Goode, VABuilt 1978 · S/N 17271256 N2377LBarnes Matthew · Cost, TXS/N M-217 N2377PLammers William Scott · Deer Park, ILBuilt 1998 · S/N 18280434 N2377UCardinal Flight Systems LLC · Cary, NCBuilt 1979 · S/N 28-8016021 N2377YTerral William C · Farmerville, LABuilt 1998 · S/N 18280436

Back to AD 81-18-04 R2