AD 81-18-04 R2

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
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.

N6027CShough Mark E · Bemidji, MNBuilt 1978 · S/N R18200358N6027DSnyder Logan J · Wasilla, AKBuilt 1956 · S/N 22-4680N6027PJourney Over Destination Aviation LLC · Golden, COBuilt 1959 · S/N 24-1122N6027QBergh Robert P · Hammett, IDS/N 874N6027ZSpacely Space Sprockets LLC · Aurora, ORBuilt 2006 · S/N 172S10159N6028CPopejoy Gregory M · Sacramento, CABuilt 1954 · S/N 137-4N6028QSky Partners LLC · Sylacauga, ALBuilt 1965 · S/N 875N6028XHarnagel Duard R · Scottsdale, AZBuilt 1960 · S/N 1618N6028YPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 2006 · S/N 172S10173N6029BSchmidt Glenn J · Wesley Chapel, FLBuilt 1994 · S/N 14613N6029DRonnie L Tremain · Sherwood, ORBuilt 1956 · S/N 22-4682N6029QHill John T · Saint Augustine, FLBuilt 1965 · S/N 3235N6029WWalsh Robert D · Somerset, CABuilt 1964 · S/N 28-20029N602AKimberlin Lisa · San Francisco, CABuilt 1951 · S/N 22-5N602BCN602bc LLC · Wasilla, AKBuilt 2007 · S/N 105N602CBWray David A · Louisville, KYS/N 446-18-1830N602CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283072N602DTFollow Your Bliss LLC · Woodbury, MNBuilt 1980 · S/N 28-8011118N602EPJones Theodore R · Prospect, KYBuilt 2002 · S/N 70382N602EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12698N602FLRoberts David R · West Newton, MABuilt 1971 · S/N 28-7125476N602FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7716056N602HKing John H · Trumansburg, NYBuilt 1977 · S/N 1077N602JAAllen John S · Pasadena, CABuilt 2001 · S/N 001N602JYN13303 LLC · Miami, FLS/N 17262651N602NDRainer Flight Service LLC · Renton, WABuilt 2012 · S/N 172S11253N602PCJ & P Aviation LLC · Plymouth, MABuilt 1979 · S/N 28-7990581N602RVQuick Comfort Inc · Allen, KSBuilt 2001 · S/N 60310N602TLCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10736N602TPChemic Plane LLC · Grand Rapids, MIBuilt 1981 · S/N 62P09078165035N602TWChrysalide LLC · Oklahoma City, OKS/N 1N602UTecnam US Inc · Sebring, FLBuilt 2023 · S/N 206/USN602WKStrange River Inc · Dripping Springs, TXBuilt 1983 · S/N 60-8365019N602WTCary Steven B · Brookshire, TXBuilt 2007 · S/N 40336N602ZRegistration Pending · Mullica Hill, NJRegistration pendingBuilt 1965 · S/N 290N6030CJames Marvin L · Scio, ORBuilt 1955 · S/N 143-5AN6030DKnipper Larry R · New Lenox, ILBuilt 1956 · S/N 22-4683N6030FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020093N6030PAngel Aviation LLC · Paradise, KSBuilt 1959 · S/N 24-1126N6031DCeruto Jorge · Auburndale, FLS/N 22-4684N6031EHigh Exposure Inc · Wilmington, DEBuilt 1978 · S/N 17271984N6031FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020094N6031LRegistered aircraftBuilt 2006 · S/N 172S10188N6031QWhittier Frank · Las Vegas, NVBuilt 1965 · S/N 876N6031WWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10189N6032DBravo Gulf Zulu Aviation LLC · Newark, DEBuilt 2006 · S/N 18281820N6032PStarrynight Bonanza Group LLC · Brighton, COBuilt 1959 · S/N 24-1128N60337Lewis University · Romeoville, ILBuilt 2006 · S/N 172S10192N6033A3v Global LLC · Clermont, GABuilt 1994 · S/N 14616N6033FSky View Aviation LLC · Benton, KYBuilt 1965 · S/N TD-626
Back to AD 81-18-04 R2