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.
N22CCLegacy Air LLC · Oklahoma City, OKN22CFGame Equipment Services LLC · Midland, TXN22CJCleveland Adam · Abilene, TXN22CKAdams Ventures LLC · Lowell, ARN22CVMcginley Donald J · Port Orange, FLN22DECrawford Edgar A · Locust Grove, GAN22DRScott Aero LLC · Hudson Oaks, TXN22DSSwartwout David C · Sedona, AZN22DTMartin Communications Inc · West Monroe, LAN22DVSamoilenko Nadia S · Hillsborough, NCN22DXHawk Daniel G · Cocoa, FLN22ECDoose Christopher A · Memphis, TNN22EDGrant Douglas R · Foster City, CAFirst renewal noticeN22EPRobinson Michael · Tucson, AZN22EWHoltaway Robert F · Bullock, NCN22FBWilson Travis · Beaver Dam, KYN22FGState Of California Department Of Fish And Game · Sacramento, CAN22FHPapasavas Paul A · West Orange, NJN22GBHolland Kenneth F Trustee · Santa Clarita, CAN22GCSkydive Ky LLC · Cecilia, KYN22GDMagafly LLC · Bay City, MIN22GJTaffet Jay · New Orleans, LAN22GPDunkelburg David L · Milton Freewater, ORN22HABig Bend Aviation LLC · Odessa, TXN22HBHubele Conrad · Tucson, AZN22HGFreeno Joseph · Upland, CAN22HRSpletzer Carl W · Selma, ORN22JLWasson James L · Tyler, TXN22JYYoung James Frederic Sr · Shepherdstown, WVN22KMTorris Warren E · San Dimas, CAN22KSWhite Brian · Forsyth, GAN22LMRd Aire LLC · Opelika, ALN22LW22lw LLC · New Port Richey, FLN22MDewitt Josiah · Renton, WAN22MJKnapp Ronald P · Los Gatos, CAN22MMAerospace Quality LLC · Piggott, ARN22NEEvmed LLC · Littleton, NCN22NLD2k Aviation LLC · Boyden, IAN22NNInternational Air Services Inc Trustee · Carson City, NVN22NPPayne David · Maryville, TNN22NSWeachock Michael J · Franklin Park, NJN22PKRegistered aircraftN22PTGuy Transportation Ltd · Wilmington, DEN22PWGoldsboro Flight Club LLC · Faison, NCN22QWCaiati Ulysses H · Fresno, CAN22REStanley Aero Club Inc · Belmont, NCN22RJSandhu Balraj S · Fairfield, CAN22RNTre Ventures LLC · Mount Olive, NCN22RRHolmes Amy N · Madison Heights, VAN22RSLechner Douglas K · Needham, IN
Back to AD 98-21-21 R1