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.

N35564Port Townsend Aero Museum · Port Townsend, WABuilt 1968 · S/N 17256838 N35565Cochran Brent D · Sandy Valley, NVBuilt 1968 · S/N 17256839 N35567Searfus Kirsten · Durango, COBuilt 1968 · S/N 17256840 N35568Advance Development Inc · Muskogee, OKBuilt 1976 · S/N 177RG1053 N35569Long Daniel W · Carrollton, GABuilt 1968 · S/N 17256841 N3556MHubbert Robert · Azle, TXS/N 12-2501 N3556PPlanes & Things Inc · Collinsville, OKBuilt 1955 · S/N 22-3312 N3556VWestbank Fishing LLC · Kiln, MSBuilt 2001 · S/N 18281009 N35575Sky Flight Robotics Inc · Freeland, MIS/N 17256845 N35577Griffin Terry R · Rock Hill, SCBuilt 1968 · S/N 17256846 N35578Christiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S8867 N3557AWalter Jerry Douglas II · Palm Beach Gardens, FLS/N 22-1831 N3557KEastern Aeroworks LLC · Punxsutawney, PAS/N 28-23627 N3557MMacniven Donald B · Colorado Springs, COS/N 12-2500 N3557YNoble Stewart G · Reno, NVBuilt 1966 · S/N 30-1078 N35581N35581 LLC · Longview, TXBuilt 1968 · S/N 17256848 N35586Smith John S · Easthampton, MABuilt 1968 · S/N 17256853 N3558AKra Investments LLC · Eastport, IDBuilt 1953 · S/N 22-1832 N3558EVisalia Flyers LLC · Visalia, CABuilt 1978 · S/N 17271586 N3558MHale Mitchell D · Chugiak, AKFirst renewal noticeS/N 12-2404 N3558PConly Vernon J · Lehigh Acres, FLBuilt 1955 · S/N 22-3314 N35590Bas Part Sales LLC · Greeley, COBuilt 1979 · S/N 32R-8013020 N3559CDelta Blue Line LLC · Collierville, TNBuilt 1979 · S/N 32-7940279 N3559DStuder Edward J · Ballinger, TXBuilt 1979 · S/N 28-8011057 N3559HTipps Brandon · Shelbyville, TNBuilt 1977 · S/N 20-1233 N3559MMoyer Josiah E · Paradise, PABuilt 1978 · S/N 28R-7837124 N3559RWest Indies Aviation Corp Trustee · Wilmington, DEBuilt 2001 · S/N 18281011 N3559ULewis Tyler Dean · Bullard, TXBuilt 1979 · S/N 32R-8013018 N3559WSherlin Grover W · Garland, TXBuilt 1966 · S/N 32-448 N3559XSpon Water Consulting LLC · South Beloit, ILBuilt 1979 · S/N 32R-8013019 N3559ZLapp Matthew J · Bonners Ferry, IDBuilt 1960 · S/N 22-7472 N355AAAbove All Aviation Inc · Santa Barbara, CABuilt 1980 · S/N 15284224 N355ABXin Han Aviation LLC · Atwater, CABuilt 2001 · S/N 4496093 N355ASPollux Aviation Ltd · Wasilla, AKBuilt 2003 · S/N 10061 N355BGGrabhorn Bart · Scappoose, ORBuilt 2021 · S/N 613-2021 N355CBM S T S LLC · Moses Lake, WABuilt 1991 · S/N 4091C N355CMHanson Hans E · Anchorage, AKFirst renewal noticeBuilt 2006 · S/N 2358 N355CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281507 N355DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843843 N355DHDofka Martin F III · Wheeling, WVBuilt 2010 · S/N 71624 N355GPersonal Aviation Inc · Poway, CABuilt 1979 · S/N 17272564 N355GWValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 172S9355 N355JDCrop Duster Steve Inc · Sheridan, WYS/N R109 N355JHEmm USA Inc · Lewes, DEBuilt 1973 · S/N 32-7340116 N355JPBryant Bruce B · Raymond, KSBuilt 1955 · S/N 22-3311 N355LGLilienthal Michael · Las Vegas, NVBuilt 1969 · S/N 28-5462 N355MDelaware Trust Company Owner Trustee · Wilmington, DES/N 273972 N355MEBode Aviation Inc · Albuquerque, NMBuilt 2000 · S/N 172S8590 N355MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881502 N355RKWithers Dennis L · Hillsboro, OHBuilt 1971 · S/N 140

Back to AD 81-18-04 R2