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.

N44YUDoane Mica S · Meno, OKBuilt 2011 · S/N 64 N44YYYankee LLC · Kasilof, AKBuilt 1979 · S/N 18-7909069 N44ZCMarker Michael M Jr · Los Lunas, NMBuilt 1985 · S/N 4 N44ZWTurner Robert H · San Diego, CABuilt 1977 · S/N 322-77 N4500RWork Edward · Sneads Ferry, NCBuilt 1965 · S/N 28-21199 N4500WMagalsky Jacob J · Wilsall, MTBuilt 1980 · S/N 18-8009019 N4500ZBielefeld James L · Kenai, AKBuilt 1960 · S/N 22-8000 N4501EOptima Aviation LLC DBA · Lewisville, TXS/N 17271614 N4501HBrown Kevin · San Dimas, CABuilt 1978 · S/N 24-0750 N4501JBleem Steven L · Duncan, OKBuilt 1968 · S/N 28R-30355 N4501RNess James H · Phoenix, AZBuilt 1965 · S/N 28-21200 N4502ZBoyer Bruce A · Toledo, OHBuilt 1960 · S/N 22-8002 N4503JSkykid Adventures LLC · Cedar Valley, UTBuilt 1968 · S/N 28R-30358 N4503YSteppler Dean M · Culbertson, MTBuilt 1971 · S/N 18-8923 N4504YCronin Monty A · Gettysburg, SDBuilt 1971 · S/N 18-8924 N45050Rav Aviation LLC · Miramar, FLBuilt 1969 · S/N 27-4271 N4505ASteadman Norman W · Arlington, TXBuilt 1956 · S/N 22-3810 N4505RFayal Kenneth E Jr · Bend, ORS/N 28-21205 N4505YGeneral Air Service LLC · Van Wert, OHBuilt 1971 · S/N 18-8925 N45060Stone Eric · Cedarpines Park, CABuilt 1976 · S/N 177RG1091 N4506APennsylvania College Of Technology · Williamsport, PAS/N 22-3811 N4506MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-881 N4506RCruz Roberto Jr · Douglasville, GABuilt 1965 · S/N 28-21206 N4506TPettit Kenneth W · Madison, INBuilt 1972 · S/N 28-7225176 N4506VRegistered aircraftBuilt 1979 · S/N 28-8090026 N45077Qualitair LLC Owner Trustee · MichelstadtBuilt 1978 · S/N 28-7911291 N4507JSkvara Stanley Henry Jr · Parma, OHBuilt 1968 · S/N 28R-30363 N4507NGarnet Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 28-8090031 N4507QFrost Aviation Services Inc · Las Cruces, NMBuilt 1979 · S/N 28-8090032 N4507RFly First LLC · West Memphis, ARBuilt 1979 · S/N 28R-7918246 N4507TLoma Aviation LLC · San Diego, CABuilt 1972 · S/N 28-7205174 N4507XVanny Ravy · Winchester, CABuilt 1976 · S/N 28-7625046 N4507YEmanuels Adam C · Selma, NCBuilt 1979 · S/N 28-7911290 N45086Dahl Ken L · Granite Falls, MNBuilt 1976 · S/N 177RG1092 N4508ABonogofsky Thomas L · Bridger, MTBuilt 1956 · S/N 22-3813 N4508JWood Daniel W · Cottonwood Shores, TXBuilt 1968 · S/N 28R-30364 N4508RMcmichael Timothy J · Rock Hill, SCBuilt 1979 · S/N 32-7940245 N4508XWestchester Flying Club Inc · Purchase, NYBuilt 1975 · S/N 28-7690026 N4509HGolding Lee · Brookline, MOBuilt 1978 · S/N 24-0753 N4509XPerformance Power Services Pc · Naperville, ILBuilt 1975 · S/N 28R-7635067 N4509YWolfrum John A · Two Rivers, AKBuilt 1971 · S/N 18-8930 N4509ZLawrence Bobby L · Willis, TXBuilt 1960 · S/N 22-8011 N450AACentex Aero LLC Trustee · San Antonio, TXBuilt 2019 · S/N 2881256 N450ASConroy Philip L · Colleyville, TXBuilt 1978 · S/N 27-7854123 N450BASimmons Brian R · Heavener, OKBuilt 1981 · S/N M-2342 N450CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881122 N450DLBay Larry · San Diego, CABuilt 2003 · S/N 10236 N450EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12955 N450EZBassen Gerald R · St George, UTBuilt 1984 · S/N 2165 N450FLMorriss Aviation LLC · Allen, TXBuilt 1971 · S/N 28-7125243

Back to AD 81-18-04 R2