AD 98-21-21 R1
Registered aircraft · 85,620
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.
N2315CRegistered aircraftN2315DFeher Eugene A · Greenwich, NYN2315FRed Rock Aircraft Leasing LLC · Hurricane, UTN2315GClark Jeffrey E · Tiburon, CAN2315TFaraone Nicholas Robert · Saint Petersburg, FLN2315XParker Ronald Lewis · Melissa, TXN2316CTwo Wings LLC · Anchorage, AKN2316FTip Of The Tusk Aviation LLC · Siloam Springs, ARN2316KAverett University · Danville, VAN2317GOrion Aviation LLC · Edmond, OKN2317MHilton Head Flyers LLC · Liberty, SCN2317SSokoloff James T · Cambridge, MAN2317TShirley Aviation LLC · Alexandria, VAN2317VMay-Collier Aviation LLC · Atlanta, GAN2317XSproul Wendell C · Hermon, MEN2318ATarpley Gary H · Seaford, VAN2318CWebster Robert C · East Jordan, MIN2318FBe Dozer LLC · Guy, ARN2318GRedmond John R · Reno, NVN2318RJigamian Geoffrey T · Temecula, CAN2318TBenedict James C II · Douglasville, GAN2319FDelaney Patrick J · Marion, TXN2319GSkydive Co · Fairburn, GAN2319SHotel Whiskey Aviation LLC · San Antonio, TXN2319TJensen Betty K · Ithaca, NYN2319UGriffin Edward L · Bowling Green, KYN231ACHinsdale Jeffrey M · Ionia, NYN231AEJda Properties LLC · Stillwater, MNN231AFPistora Steven R Trustee · Lindsborg, KSN231AGQualitair LLC Trustee · MichelstadtN231AJFrimodig James P · San Diego, CAN231AKKab Flyers LLC · Greenville, ILN231ALBaryon Aero LLC · Culver City, CAN231APHoneyland Inc · Wolf Point, MTN231AQHenslee Christopher S · Grass Valley, CAN231ARMabry Danny W · Morehead, KYN231ASSkousen Joel M · Spring City, UTN231ATMuncy Donald A · Corinth, TXN231AURouw Bruce · Leesburg, FLN231AYDelgado Erick · Tucson, AZN231AZSpirit Aviation N231az LLC · Austin, TXN231BBlue River Holdings LLC · Hugo, OKN231BADykstra Darren J · Pacific Grove, CAFirst renewal noticeN231BCFlying Elite Inc · Wilmington, DEN231BDNicholls Samuel H · Brookfield, ILN231BGWojteczko Jason A · Derby, KSN231BHStefenelli Aviation N-Tr Inc Trustee · AtterseeN231BLSolethium Lc · Jonesboro, ARN231BMLee Judy K · Nashport, OHN231BNTaylor Kent S · Watford City, ND
Back to AD 98-21-21 R1