AD 98-15-18 R1
Registered aircraft · 1,210
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-15-18-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-15-18-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-15-18-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-15-18-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.
N1050RWatrous Scott A · Warrenton, VAN1051SWhitfield David Michael · Cleveland, GAN1051TOwens Randall C · Houston, TXN1051WAir Services International Leasing LLC · Fort Lauderdale, FLN1051ZDranttel Timothy John · Fuquay Varina, NCN1052TSale Reported · Crystal, MNSale reportedN1053THenderson State University · Arkadelphia, ARN10550Edwards Robert · Daphne, ALN10555Mccrea Daniel B · Waldport, ORN1055CPerry Scott R · Klamath Falls, ORN1055JEmbry William Mark · Gifford, WAN1055TWeiss Martin T · Aquinnah, MAN1055XDcfly LLC. · Bessemer City, NCN1055ZLikovich Robert B Jr · Wake Forest, NCN1058TRock Island Aviation Inc · Wilmington, DEN107AKLazzaro Chris C · Solvang, CAN108FBPlane Fun Inc Tr Trustee · Snellville, GAN108HGKillam Galen Mark · Wautoma, WIN10SYBellany Mark A · Freeville, NYN1101TThompson Thomas Brian · San Francisco, CAN110HSHenderson State University · Arkadelphia, ARN11101Perin Jeffrey S · Wasilla, AKN111KDWedekemper Steven E · Brighton, MIN112CPBradley Aviation LLC · Columbus, INN114HSHenderson State University · Arkadelphia, ARN114MKGood Thomas Ryan · Grapevine, TXN114WMMaule Flight LLC · Nashville, INN116GRegistration Pending · Sheridan, WYRegistration pendingN118GSparks Brian E · Monmouth, ORN11UGBrandemuehl Joseph J · Boscobel, WIN11ZARanch Aero LLC · Sterling City, TXN11ZVWebb Group Flp · Jackson, MSN12008Dvoracek Dana J · Charlevoix, MIN12009Jordan Ronald W · Stoutsville, OHN12011Marsh John Edward · Washington, DCN12014Thompson Robert J · Kaktovik, AKN12015Thurmond Paul J · Huntley, MTN12016Swain Michael J · Jacksonville, FLN12017Nuckles Charles Austin Jr · Suffolk, VAN12018Theriot Harris J Jr · Thibodaux, LAN12026Bernhardt Michael J · North Branch, MNN12027Rugland Roger E · Anoka, MNN12029Dippold Lois M · Perry, MIN12031Burnett Brandon Ryan · White Lake, MIN12032Riebe Robert D · Caldwell, IDN120AGHallmark Ronald D · Spring Hill, TNN120GBug Air LLC · Anchorage, AKN122CPFlorida Seaplanes LLC · Altamonte Springs, FLN122WANagle Derek T · Ada, MIN123PPHyman Martin Am · Saunderstown, RI
Back to AD 98-15-18 R1