OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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:99-01-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
  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.

N6853ZChristian Aviation LLC · Pearland, TXBuilt 1963 · S/N 25-2534N6854KMountain Air · Cody, WYBuilt 1949 · S/N 16-689N6855BSmith Cody P · Fairbanks, AKS/N 22-4153N6856BEberly Joshua D · Middletown, OHBuilt 1956 · S/N 22-4156N6856KWyborny Elton D · Scotland, ARBuilt 1949 · S/N 16-692N6857ZBarrett Jane T · Tehachapi, CABuilt 1963 · S/N 25-2538N6858KPreston Benjamin J · Sonoma, CABuilt 1949 · S/N 16-694N6859KShelton Gregory S · Midlothian, VABuilt 1949 · S/N 16-695N6859ZEd Air Inc · Oaktown, INBuilt 1963 · S/N 25-2540N6862ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1963 · S/N 25-2548N6864KMedina-Solla Edwin O · Trujillo Alto, PRS/N 16-700N6865BEllis Ray Lynn · Lakeside, CABuilt 1956 · S/N 22-4165N6865KSvendsen Jon · Wasilla, AKBuilt 1949 · S/N 16-701N6867BMarx Nathan L · Sauk City, WIFirst renewal noticeS/N 22-4167N6867KFloyd Roger L · Sedan, KSS/N 16-703N6868ZC-Fleet LLC · Missoula, MTBuilt 1963 · S/N 25-2574N6869KFelix Leonard D Jr · Salome, AZBuilt 1949 · S/N 16-704N6870KYruegas Luis Jr · San Antonio, TXBuilt 1949 · S/N 16-705N6873BBent James L Jr DBA · Palatine Bridge, NYS/N 18-5053N6874BSale Reported · Mentor, OHSale reportedS/N 22-4118N6875BCyr Kevin M · Brush, COS/N 22-4119N6876KAndrews Thomas J · Lakeview, ORS/N 16-717N6877KLaurienzo Andrew A · Clarence, NYBuilt 1949 · S/N 16-720N6878BCriner Brad W · Canby, CABuilt 1959 · S/N 18-5061N6878KMitchell David R · Conover, NCBuilt 1949 · S/N 16-721N6880BAllmaras Donald P · New Rockford, NDBuilt 1956 · S/N 18-5067N6880ZMayes Brett R · Williams, CAS/N 25-2605N6881KTime 2 Fly LLC · Baldwinsville, NYBuilt 1979 · S/N 16-724N6883BSlagle Allen E · Newcastle, WYBuilt 1956 · S/N 18-5070N6883KDrb Helicopters LLC · Klamath Falls, ORS/N 16-726N6883ZFoster Gary L · Palmer, AKBuilt 1964 · S/N 18-8136N6884KWyatt Mary Ellen Personal Representative · Weirsdale, FLBuilt 1949 · S/N 16-728N6886BOhmans Inc · Gillette, WYBuilt 1956 · S/N 18-5073N6887KAtmospheric Vehicle & Spacecraft Flight Exploratio · Rch Palos Vrd, CAS/N 16-731N6888BVenell Farms Inc · Corvallis, ORBuilt 1956 · S/N 18-5076N6891BSchachle Theodore A · Willow, AKS/N 18-5080N68931Denman Diana L · Plain, WIBuilt 1943 · S/N 5-1436N6893ZAg Air Squadron Three LLC · Saint Joseph, ILBuilt 1964 · S/N 25-2620N6895KRiemer Emil F · Brush Prairie, WABuilt 1951 · S/N 20-670N6897BCape May Aerial Advertising LLC · Cape May Ch, NJBuilt 1956 · S/N 18-5084N689AW Grotendiek LLC · Portland, ORBuilt 1951 · S/N 22-92N68EEBurtt John B · Pierson, MIBuilt 1975 · S/N 18-7509087N68FSistrunk Donald M · Ragley, LABuilt 1956 · S/N 22-4107N68LKKing Larry E Jr · Wenatchee, WABuilt 1968 · S/N 18-8642N6900DMahoney Shane · Auburn, WABuilt 1957 · S/N 22-4827N6900ZIndependence Glider Club · Independence, ORBuilt 1964 · S/N 25-2634N6902DFerrell Alan B · Arlington, OHBuilt 1957 · S/N 22-4829N6903BJones Gary L · Kerrville, TXBuilt 1956 · S/N 22-4175N6904DLucas Michael F · Germantown, OHS/N 22-4831N6904KHolcomb Garry M · Point, TXS/N 20-33
Back to AD 99-01-05 R1