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.
N13383Alpha Aviation-1 LLC · Naples, FLN13384Premier Vacations LLC · Haines City, FLN13386Crosswind Aviation Of Oklahoma LLC · Stillwater, OKN1338FVogel Auto Repair LLC · Palmer, NEN1338GWings Air Charter LLC · Wisconsin Rapids, WIN1338YRegistered aircraftN13391Brazos Valley Flight Services LLC · College Station, TXN13394Ck Leasing Services LLC · Wilmington, DEN13399Great Plains Spraying Inc · Colby, KSN1339FFriedlander Edward R · Hattiesburg, MSN1339GLyon Aviation Inc · Pittsfield, MAN1339W39 Whiskey LLC · Clovis, NMN1339YMiller Henry C · Mckinney, TXN1339ZSmith Derek D · Brooks, GAN133AGRaritan Valley Flying School · Princeton, NJN133BSMusser Merton · Billings, MTN133CBBrown Milton S III · Raleigh, NCN133CGRoq Farm LLC · Diboll, TXN133CLDukes Grant M · Horseshoe Bay, TXN133CTValiair Lc Trustee · Casper, WYN133CWDeniro Corp · Hampton, NHN133DB3h Mech LLC · Grand Junction, CON133DSHagopian Donald D · Van Nuys, CAN133ECMf33a Enterprises LLC · Amarillo, TXN133EMWheels Up LLC · Lincoln, NEN133FCWisdom Blake Andrew · Chapmansboro, TNN133GMBem Holdings LLC · Nashville, TNN133LBlair Byron · Ajo, AZN133MGolden Age Flight Museum · Bakersfield, CAN133MDWells Rich · Aspen, CON133MRPrecision Aero LLC · Wilmington, DEN133MWSky Mile Limit · Murrayville, GAN133PTKittle David · Siloam Springs, ARN133QFreeland Christopher G · Brownwood, TXN133RJKirby Kevin M · Dayton, OHFirst renewal noticeN133SBColeman Terry Michael · Meridianville, ALN133SFNelson Dennis E · Jamestown, NDN133SMSpivack Peter · Philadelphia, PAN133TDLanyi Clifford · Attleboro, MAN133TSHunter Stephen Eugene · Grace, MSN133VMCathey Gary C · El Dorado Hills, CAN133VWAlpine Katmai LLC · Alpine, WYN13400Opolka John G · Midlothian, TXN13402Cartwright Edward N · Winterville, NCN13404Kroner David S · Rock Creek, OHN13405Kelley Aircraft LLC · Weyers Cave, VAN13406Shore Stephen A · Thurmond, NCN1340TMaw Enterprises USA LLC · Hudson, FLN1340WJohnson Jon · El Paso, TXN1340YStephens Christopher L · Kelso, WA
Back to AD 98-21-21 R1