AD 98-01-06
Registered aircraft · 72,832
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-01-06')
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-01-06')
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-01-06') 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-01-06') 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.
N100CRFreudenberg Joseph B · Almira, WAN100DFFisher Charlton Dru · Houston, TXN100DPEskind Thomas O Jr · Dallas, TXN100DVHarvey Donald W · Concord, NCN100FAAlmost Heaven Aviation LLC · Morgantown, WVN100KN18t Ltd · Wilmington, DEN100KCMiller Byron W · Silverton, ORFirst renewal noticeN100KHLefevers Adam · Pineville, KYN100LDPenning Jeffrey D · Clear Lake, IAN100MSky Odyssey Aviation LLC · Gulf Breeze, FLN100PTJacobs Brian E · Aptos, CAN100RFN100rf Ghost LLC · Burleson, TXN100RKEllingson Leslie B · Harwood, NDN100SQBowles Chris · Taylorsville, NCN100SVKretschman Thomas J · Verona, WIN100SXKing Samuel E · Battle Mountain, NVN100THWhiddon Mark H · Frankston, TXN100TNMoore Glenn C · Elkhart Lake, WIN100UDVogel Kelly C · Ventura, CAN100ULEvans Hugh E · Lafayette, LAN100WAAlcorn Stanley R · Sonora, CAN100WHTowb Parmalee · Chula Vista, CAN100WRBuehler Andrew · Eatonville, WAN100WWSwearengin David · Lula, GAN100XXAskew Stell Blake III · Durham, NCN100YAShelton Joel T · Grass Valley, CAN100YSLally Lawrence L · Mooresville, NCN100ZYWalden Taylor G · Pueblo, CON101Bene Mary D · Ketchum, OKFirst renewal noticeN10101Mcnaughton Robert R Jr · New Alexandria, PAN10104Tanami Harel · Los Angeles, CAN10105Wild Blue Aviation LLC · Eagle Rock, MON1010HA2 Aero LLC · Ann Arbor, MIN1010MSimpson Kendal L · Port Orange, FLN1010QBurklund Joel H · Minneapolis, MNN1010RKaneair LLC · Hayes, VAN1011AMachamer John K · Gettysburg, PAN1011HUlm Gabrielle Nicole · North Pole, AKN1011NBlue Skies Aircraft LLC · Zephyrhills, FLN1011TPedersen Michael · Bakersfield, CAN1011ZChiappe Richard S · Estes Park, CON1012Papon Bruce · Hardtner, KSN1012ASimmons Michael T · Carolina Beach, NCN1012GForwalt Lucas A · Chesapeake, VAN10130Blunt Alan W · Granger, INN10131Bp2 Construction LLC · Seymour, INN10134Scarbrough Mark B · San Miguel, CAN10136Rowe Michael · Chesterfield, MON1013EFouts Chester L · Turner, MTN1013HWhite Theodore F · Willow, AK
Back to AD 98-01-06