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.
N2306FBas Part Sales LLC · Greeley, CON2306RRenshaw Laurence A · Cave Creek, AZN23078Pureflight Aviation Training LLC · Newberg, ORN2307CStuffmann Eric S · Orinda, CAN2307DSunderland Paul · Savannah, GAN2307FEads Kevin · Arley, ALN2307JMidwest Kilo Delta LLC · Clara City, MNN2307RSugiono Oliver C · San Marino, CAN2307UCowgar Jeremy N · Norton, OHN2307XCornwall Brady Evan M · Shelton, WAN2308EPavco Inc · Gig Harbor, WAN2308TBugarchich Christopher Z · Stratford, CTN2309GEquipment & Machinery Appraisal LLC · Grand Junction, CON230ASN230as LLC · Wilmington, DEN230BLafitte John B · Villa Rica, GAN230DAHot Seat Aviation · Blacksburg, VAN230DDStrobe 33 LLC · Houston, TXN230EASea Hawk Airways LLC · Largo, FLN230JCN230jc Inc Trustee · Wilmington, DEN230MAviation Developers Inc · Highlandville, MON230MJVne LLC · Sheridan, WYN230MMLackey Matthew Allen · Peachtree City, GAN230PLudian Malgorzata · Bakersfield, CAN230QKuper Carl J II · Dalhart, TXN230RVEast Tennessee Aviation LLC · Mountain City, TNN230SUBoelte Aviation LLC · Wilmington, DEN230SWMartin Co · Tyrone, GAN230UBoard Of Regents · Norman, OKN230XHHowell William J · Portola Valley, CAN2310RMccarty Brian Keith · Huntsville, TXN2310UTec Aviation LLC · Euclid, OHN2311CB & B Aviation LLC · Wayzata, MNN2311DTwombly Eric D · Halfway, ORN2311FPace Seth M · Malibu, CAN2311GVan Winkle Randy M · Van Buren, MON2311TAlanair LLC · Red Hook, NYN2311UDcy Flyers Inc · Montgomery, INN2311VB & L Henry LLC · Chipley, FLN2312FButler Scotty · Yukon, OKN2312REagy Gregory L · Boise, IDN2312XCain James W · Big Rapids, MIN23138Donaldson Docks Inc · Estherville, IAN2313RBlackman David M Trustee · Pacifica, CAN2313UNobles Homer L III · Sandy Valley, NVN2313ZT R Gemelli Holding Co LLC · Wilmington, DEN2314EAirgo Inc · Centralia, ILN2314GFallang Paul Sam · Great Falls, MTN2314RWilson George L · Hideaway, TXN2314UCms Crawford Maintenance Services LLC · Largo, FLN2314XFlight Resources LLC · Monroe, GA
Back to AD 98-21-21 R1