Registered aircraft · 81,733

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.

N3633AMartin Michael O · Frisco, TXBuilt 1954 · S/N 22-1891 N3633MBrekhus Rickey G · Kenmare, NDBuilt 1947 · S/N 12-2521 N3633NPerotti Camille C · Carolina Beach, NCBuilt 1967 · S/N 680019 N3633RGrammar Adrian Gates · Geneva, NYBuilt 1970 · S/N 28-5728 N36349Richardson Thomas R · Valleyford, WABuilt 1973 · S/N 967-73 N3634RRatkovich Stephen · Prospect Heights, ILBuilt 1971 · S/N 28-7125140 N3634WCarey Nicholas Isaac · Clarkston, WABuilt 1966 · S/N 32-536 N3634YKahn-Air LLC · Rumson, NJBuilt 1980 · S/N 6007708061233 N36350Hennager Eric D · Langdon, NDBuilt 1973 · S/N 272-73 N36351Mueller Michael A · Seguin, TXBuilt 1973 · S/N 567-73 N36352Smith Steven Glen Trustee · Orem, UTBuilt 1973 · S/N 108-73 N36353Mcbride Mark · Sutton, MABuilt 1973 · S/N 968-73 N36355Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816630 N36358Hans Aviation Inc · Davie, FLBuilt 1978 · S/N 28-7816631 N3635ACaljet Inc · Van Nuys, CABuilt 1980 · S/N 61P07748063387 N3635MSomd Seaplanes LLC · Lexington Park, MDBuilt 1947 · S/N 12-2479 N3635QFantini Real Estate LLC · Louisville, KYBuilt 1967 · S/N MB-246 N3635TFlorida Wings LLC · Wilmington, DEBuilt 2017 · S/N 058/US N3635WSwieter Avionics LLC · Waverly, IAS/N 32-537 N3635XInternational Air Charter Inc · Intl Falls, MNS/N 5084 N3635YGo Mango LLC · Las Vegas, NVBuilt 1980 · S/N 61P07818063394 N3635ZRiggi Dean A · Scotia, NYBuilt 1960 · S/N 22-7530 N36361Smith Robert Ervin III · Mountain Top, PABuilt 1978 · S/N 32-7840158 N36364Gordon Security Solutions LLC · Chester Springs, PABuilt 1978 · S/N 32-7840159 N3636KCronin John M · Bremerton, WABuilt 1967 · S/N 28-23662 N3636WAltitude Aviation Services LLC · Mountain Home, IDBuilt 1990 · S/N 1345 N3637CThree Seven Charlie LLC · Camp Hill, PABuilt 1978 · S/N R18200288 N3637PBlazek Troy L · Cottage Grove, MNBuilt 1955 · S/N 22-3374 N3637RGelinger Gary · Cape Carteret, NCBuilt 1970 · S/N 28-5732 N3637WStruck Dennis L · Spirit Lake, IABuilt 1966 · S/N 32-539 N3637ZFord Kristy M · Marianna, FLBuilt 1960 · S/N 22-7532 N36382Pallaziol Delia N · Vista, CABuilt 1973 · S/N 389-73 N36384Lisa Rocco J · Elkhart, INBuilt 1978 · S/N 28R-7837277 N36387Hlavin Mark S Trustee · Lakewood Ranch, FLBuilt 1981 · S/N 6008778161249 N3638AManifee Doris Darlene · Black Canyon City, AZBuilt 1954 · S/N 22-1896 N3638HQuantie Harold G · Locust Grove, OKS/N 20-1256 N3638MWadlington Robert S · Colorado City, COBuilt 1947 · S/N 12-2482 N3638PSorrell Byron D · Warren, MIBuilt 1955 · S/N 22-3389 N3638QWinder Keven S · Castle Rock, COBuilt 1967 · S/N MB-251 N3638RDukeman James C · Apex, NCBuilt 1970 · S/N 28-5735 N3638WCherokee Six LLC · Williamson, GABuilt 1966 · S/N 32-540 N36393Meriden Aviation Center LLC · Meriden, CTS/N 28-7816633 N36395Brittle Aviation LLC · Chapel Hill, NCBuilt 1978 · S/N 28-7816634 N3639HBeatty Earl IV · Gambrills, MDBuilt 1978 · S/N 20-1257 N3639PJoseph Patrick S · Saint Charles, MOBuilt 1955 · S/N 22-3390 N3639WYoungpeter David L · Spencerville, OHBuilt 1966 · S/N 32-542 N3639ZStahl Calvin D · Auburn, WABuilt 1960 · S/N 22-7534 N363ACAig Aeronautics LLC · Guaynabo, PRBuilt 2000 · S/N 3246161 N363BLElizabeth City State University · Elizabeth City, NCBuilt 2004 · S/N 172S9741 N363CHHautamaki Charles A · Loveland, COBuilt 2024 · S/N 7411

Back to AD 81-18-04 R2