AD 98-21-21 R1
Registered aircraft · 85,616
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:98-21-21-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:98-21-21-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.
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:98-21-21-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:98-21-21-R1') 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.
N119JLMayo Clive S · Palmetto Bay, FLN119JSFennen David A · Katy, TXN119LMRegistered aircraftN119MBWagner Mike · Godley, TXN119MSAeronorth LLC · Ann Arbor, MIN119P4dw Interests LLC · Longview, TXN119PCAc Sales & Investments LLC · Hickory, NCN119RBDetroit Lakes Aviation Inc · Detroit Lakes, MNN119RKHtv Music Co · Franklin, TNN119TTBurrell Anthony · Stillwater, OKN119TWCarter Flygare Inc · Sacramento, CAN119WRatliff Hayden N · Clarkesville, GAN119WCSmith Steven W · Kodiak, AKN11ACN11ac LLC · Lighthouse Point, FLN11APAp Aero LLC · Oklahoma City, OKN11ATChan Roger J · Anchorage, AKN11AXLoukopoulos George Matthew · Tucson, AZN11BCBledsoe Lucile M · Wray, CON11BTBravo Tango LLC · Minden, LAN11BXMatthew K Cole · Gillespie, ILN11CSilicz Nicholas J · Shafter, CAN11CASky Dragon LLC · Atlanta, GAN11CEMelcher Pierre S · New Braunfels, TXN11CFKrens Janet E · Purcellville, VAN11CGComanche 260b-N11cg · Pomeroy, WAN11CVStoots Christa M · Tucson, AZN11CWJabez Aviation LLC · Petaluma, CAN11DEPeile Kelly · Lakeview, ORN11DHRegistered aircraftN11DZLowe Jacob · Knoxville, TNN11ESale Reported · Wayne, NESale reported, canceledN11ECBasler Turbo Conversions LLC · Oshkosh, WIN11EMEstus Chad · North Las Vegas, NVN11EVBonita Beech LLC · Bonita Springs, FLN11FCCooper Matthew A · Seattle, WAN11FFJet Speed Aviation Inc · Las Vegas, NVN11FJPetit Chris J · Marrero, LAN11FLBell Christopher K · Ashley, OHN11FPShannon Rcs LLC · Kalispell, MTN11FRMosley John E · Jackson, MSN11GERusso James F · Liberty, SCN11GGGallagher Aviation LLC · Cincinnati, OHN11GKBaden Michael · Waxhaw, NCN11GMPlatt Tony E · Riverside, CAN11GNHaley James M Trustee · Edmond, OKN11GXWestrum Enterprises LLC · Norwalk, IAN11HAVintage Aero Inc · Brandon, FLN11HHRegistration Pending · Durango, CORegistration pendingN11HKJohnson Wendell F · Harlingen, TXN11HRHf Aero LLC · Lusby, MD
Back to AD 98-21-21 R1