AD 98-21-21 R1
Registered aircraft · 85,612
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.
N2709LGuideair LLC · Eden Prairie, MNN2709UGeist Paul J · Landenberg, PAN2709XCmvii LLC · Chugiak, AKN270ATsg Associates LLC · Stanley, NCN270AMCode 1 Flight Training LLC · Wills Point, TXN270CCEuro 2000 Inc · Merritt Island, FLN270GGSkylens LLC · Hammond, LAN270HBemenderfer Todd M · Mishawaka, INN270KFirst Gear Inc · Fort Wayne, INN270KCLeyva Kevin S · Wilbur, WAN270MLWard John L · Mexia, TXN270MRFurtado William J III DBA · Fremont, CAN270RBaxter Thomas L · Stockbridge, GAN270SASundance Airport Fbo LLC · Yukon, OKN270SMAims Community College · Greeley, CON270SUPiper Aircraft Inc · Vero Beach, FLN270SWEnvironmental Quality Control Inc · Chapel Hill, NCN270WMsc Services Inc · Hugo, OKN2710CFrazier James C · Hinesburg, VTN2710SMarshall Loraine · Cincinnati, OHN2710UCape Aerial Tours DBA · Chatham, MAN2710XReinhart Richard A · Cook, MNN2710YPink Ibis Air LLC · Vero Beach, FLN27117Chalfant William Paxson III · Concord, NCN2711CHolly Shawn L · Soldotna, AKN2711DSpinner James C · Belleville, ILN2711GAlexander Marshall J · Klamath Falls, ORN2711TLucero Nicholas T · North Hollywood, CAN2711WAerotec LLC · Denver, NCN2712CDunn Richard B · Otis, MEN2712DBlackwood R John Trustee · Salinas, CAN2712QGrotbeck Carter L · Albuquerque, NMN2712RSimply Living LLC · Fort Myers, FLN2712TJames Todd E · Lebanon, PAN2712WFadio David C · Elmira, NYN2712YCarranza Jorge Oros · Dallas, TXN2713DBlack Mountain Flying Service Ltd · Boulder City, NVN2713GPalmer Carroll W · Harper, ORN2713LFlemmer Richard W · Park City, MTN2713QJeff Jones Aircraft Company LLC · Quincy, WAN2713UAeronetica LLC · Tulsa, OKN2713WDutro Tammy S · Dublin, OHN2714DDeane Gregory H · Anacortes, WAN2714FDdh LLC · Goddard, KSN2714GRegistered aircraftN2714TVertical Flight Leasing LLC · Wilmington, DEN2715CHead Nyle C · Sisters, ORN2715DEducation Connection LLC · Port Saint Lucie, FLN2715FLow Wings Aviation LLC · Gassville, ARN2715LGoebel Christian E · Luray, VA
Back to AD 98-21-21 R1