AD 98-08-21
Registered aircraft · 64
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-08-21')
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-08-21')
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-08-21') 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-08-21') 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.
N105UTobago Six Inc · Bellevue, WAN106FI A Lele LLC · Great Falls, VAN107FRjm Aviation Partners Inc · Naples, FLN107VJdj Endeavours LLC · Downers Grove, ILN112VLebanon Valley Mobile Homes Inc · Palmyra, PAN115JHanson John Eric · Livermore, CAN115JRTobago4 LLC · Lawrenceville, GAN115NSprauer Constance D · Kensington, NHN1188RAirtrust LLC - 2 - Series 2 Trustee · Sheridan, WYN138RJBayou Flight Training LLC · Niceville, FLN151AMacnealy Gregory A · Vandalia, OHN1625LArtime Jorge Daniel · Miami Beach, FLN189TBPacca Club Inc · Attleboro, MAN197TBHardman Andrew D · Prosper, TXN1FDSiek Aviation Inc Trustee · Wilmington, DEN200STk Aviation LLC · Willow Street, PAN20AJTwigg Brett · Lincoln, ALN20DUWings Of Hope · Chesterfield, MON20ELJrhav LLC · Chassell, MIN20ETClear Skies Avionics Inc · Clearwater, FLN20EUWerking John William III · New Windsor, MDN20FVRogers Robert D Jr · Keller, TXN20JZWest William D · Newton, NCN20KGAdspitalny LLC · Waynesville, MON20KLBuell Kenneth B · Port Orange, FLN20KNShaw William C · Carmel, NYN20TKVanguard Executive LLC · Elfers, FLN2188AAircraft Guaranty Corp Trustee · Oklahoma City, OKN21AJAllcroft Roger A · Haydenville, MAN229TBRegistration Pending · Chicago, ILRegistration pendingN230GGSpace Coast Aircraft Co · Merritt Island, FLN242TBSpace Coast Aircraft Co · Merritt Island, FLN25059West William Douglas · Newton, NCN2516QKris Noone Air LLC · Wilmington, DEN25186Soule Raymond · Wiscasset, MEN2519QWhite Shane A · Fayetteville, GAN25259Miller Eric J · Mendocino, CAN276MHN276mh LLC · Ocala, FLN28170Stracar Miro · Syosset, NYN2820SJh Unlimited LLC · Kalispell, MTN2822KBrausch Jeffrey A · Avon Lake, OHN2824JSale Reported · Bangor, PASale reportedN290GTForeman Guy W · Valparaiso, INN298GTOctopus Flying Club Inc · Riverdale, MDN3039LRyan Andrew T · Manassas, VAN3048UR2 Dynamics LLC · Indianapolis, INN3059DDennerline Rhett · Northfield, ILN313DTKemp Martin K · Leesburg, VAN345GTSuncoast Aviator Inc · Wilmington, DENon-citizen corporation, flight hours not reportedN422EKWebster Eric Thomas · Austin, TX
Back to AD 98-08-21