AD 77-13-21
Registered aircraft · 3,193
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:77-13-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
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:77-13-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21') 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.
N8579PWor LLC · Jamaica Beach, TXN8582PSchwalbach Russell R · Bondurant, IAN8583PLl Aviation LLC · Kansas City, MON8583YGray Michael W · Cheyenne, WYN8584PHackens Donald G · New Underwood, SDN8585PNelson Christopher A · Silver Spring, MDN8585YGospel Ministeries International Inc · Mc Donald, TNN8586YTrue Glenn C Jr · Phoenix, AZN8590YNorthern Aviation LLC · Palmer, AKN8593YNickajack North LLC · Ocala, FLN8595YKor Reese W · Piedmont, SDN8596YLeap Aviation Inc · Wilmington, DEN8597PIsbell James R · Denison, TXN8597YTaylor Douglas S · Fairfield, CAN8598YGulf Coast Aviation LLC · New Orleans, LAN85VLBowers Jay · Farwell, TXN8600PDyer Marvin · Ackerly, TXN8600YMontcalm Kevin L · Mansfield, LAN8601PCross Robert D · Great Falls, MTN8602PMalibu Rising LLC · Phoenix, AZN8603PComanche Flyers LLC · Jefferson Township, PAN8605YFudenberg Elevated Solutions LLC · Las Vegas, NVN8606PBuhler Carey C · Mitchell, SDN8607PPeters Charles E · Fallbrook, CAN8607YMs Aero Inc · Lakeville, OHN8608PLane Vaughn S · Gonzales, LAN8610PTapert Warren F · Lenox, MIN8611YCragg Gordon E · Georgetown, TXN8612PFranz James T · Glendale, AZN8613PAkin Tiffany · Dalhart, TXN8614PLee Patrick J Jr · Lindstrom, MNN8614YD&D Maintenance LLC · Etna Green, INN8615YUniversity Of Alaska Anchorage · Anchorage, AKN8617PFrisbie Kevin R · Fairfield, IAN8618YGroup Aire II · Manitowoc, WIN8619PStewart Mark A · Mccall, IDN8619YNuse Aviation LLC · Hollidaysburg, PAN8621YParks Ashton · Pepperell, MAN8622YClosson Luke E Jr · Valdosta, GAN8623PMajor Development LLC · Cedaredge, CON8624PAviation Classics Ltd · Reno, NVN8624YRegistered aircraftN8626YThomas William R · Rochester, MNN8627PRegistered aircraftN8629YFarris Mark E · Richmond, KYN8630PSpanjer Blake L · Crete, NEN8632PCarleton Dennis M · Sewickley, PAN8632YDream Flyers LLC · Cherry Hill, NJN8635YLysiuk Lance · Andover, CTN8637PDavenport Erik Jon · Cumming, GA
Back to AD 77-13-21