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.

N5253XMaranatha Insurance Service Inc · Rancho Cucamonga, CABuilt 2002 · S/N 172S9169 N52543Berry Curtis L · Williamsport, MDBuilt 1977 · S/N 177RG1206 N52546Eaton Rosemary D · Vernon, NYS/N 17274552 N5254ABuffy Aero LLC · Suwanee, GABuilt 2002 · S/N 18281157 N5254DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272473 N5254JWorcester Naa Flying Club · Worcester, MABuilt 1980 · S/N 17273745 N5254KStone To Glass LLC · Lake Worth, FLBuilt 1980 · S/N 17274033 N5254QRocky Mountain Flight Consultants LLC · Boulder, COBuilt 2002 · S/N 172S9206 N5254WGlacier Peak Aviation LLC · Carnation, WABuilt 2002 · S/N 172S9207 N5254XDahl Kevin A · Fargo, NDBuilt 1969 · S/N 704 N5254ZPongracz Lajos Janos · San Antonio, TXBuilt 1961 · S/N 22-8939 N5255HNorth Anthony · Rockwood, MEBuilt 1949 · S/N 16-59 N5255MFlesher William Robert Jr · Gainesville, GABuilt 1978 · S/N M-2019 N5255RZin Services LLC · Dover, DEBuilt 2009 · S/N 172S10987 N5255SAkc III Aviation LLC · Port Saint Joe, FLS/N 24-1655 N5255TGood Joseph A · Weymouth, MABuilt 1972 · S/N 28-7225375 N5255UFlight Gear Aviation LLC · Pickerington, OHBuilt 1980 · S/N 172RG0304 N5255WHoppes Curt · Saint Jacob, ILBuilt 1962 · S/N 28-299 N5255ZGeorge James C · Lenoir, NCBuilt 1961 · S/N 22-8940 N5256DTall Timber Flying Service LLC · Kalispell, MTBuilt 1979 · S/N 17272475 N5256HHenley Robert J · Jeffersonville, INS/N 17265385 N5256LIngram Aviation LLC · Johns Island, SCBuilt 1967 · S/N 28-4553 N5256SFargo Jet Center LLC · Fargo, NDBuilt 2009 · S/N 172S10901 N5256ZKirkpatrick Theodore J · Gwinn, MIBuilt 1961 · S/N 22-8941 N52578Wall Leslie A Trustee · Stevensville, MDBuilt 1977 · S/N 177RG1207 N52579Urquhart David L · Winchendon, MABuilt 1977 · S/N 177RG1208 N5257ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 18282181 N5257HWellman David H · Eugene, ORBuilt 1975 · S/N 17265386 N5257PAero Nautics Inc · Cheyenne, WYS/N 24-289 N5257RTheodossiou Chris · Mandeville, LABuilt 1974 · S/N 17263471 N5257SSchumaker Grant E · Wichita, KSBuilt 1980 · S/N R18201526 N52582Wheeler Kevin K · Thornville, OHS/N 177RG1209 N52585Colley Reid W · Pauls Valley, OKS/N 177RG1210 N52589Audritsh John E DBA · Indianapolis, INBuilt 1977 · S/N 177RG1211 N5258BMathis Ryan B · Madison, ALS/N 15283818 N5258HFrenzel Carl O · Midlothian, TXBuilt 1949 · S/N 16-62 N5258PMosley Hardy · Elko, NVBuilt 1958 · S/N 24-290 N5258RZwiesler Thomas F · Ellington, CTBuilt 1974 · S/N 17263472 N5258YChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9141 N5258ZSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1981 · S/N 17275032 N52593Mccarthy Justin P · Western Springs, ILBuilt 1980 · S/N 17274559 N5259HTrifunovic Stefan · Grosse Pointe Park, MIBuilt 1975 · S/N 17265387 N5259LPennsylvania Flying Assoc Inc · Saegertown, PABuilt 1967 · S/N 28-4557 N5259PPacheco Carlos Antonio · Yuma, AZBuilt 1958 · S/N 24-293 N5259RCarnathan Robert J · Newark, CABuilt 1974 · S/N 17263473 N525AVGlobal Air Concepts LLC · Anchorage, AKBuilt 2016 · S/N GA8-16-227 N525CSPrivitt Bret J · Forest Hill, TXBuilt 1973 · S/N 270-73 N525FLSiebert Derrick R · Wausau, WIBuilt 1971 · S/N 28-7125357 N525GHLauff Samuel Jr · Ocala, FLBuilt 1964 · S/N 87 N525HFVintage Wings Aircraft LLC · Center Point, INBuilt 1977 · S/N 15280442

Back to AD 81-18-04 R2