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.
N8444YBeacon Aviation Flight Services LLC · Rogers, ARN8447PHenry Thomas Levin · Delmar, DEN8448PBissell Lee · Culver, ORN844PSDarr James E · Boron, CAFirst renewal noticeN8450PKroll Corey · Gilbert, SCN8451PReed James D II · San Antonio, TXN8452PMann Larry G · Lubbock, TXN8452YRhodes Cleo B · Dayton, VAN8455PTcb Properties Ltd · Wilmington, DEN8456PBeckmann Gerhard David · Covington, LAN8456YCfl Aircraft Sales LLC · Tampa, FLN8458PSchoolcraft Carl L · West Harrison, INN8458YOakes Michael J · Walnut Creek, CAN8459PDiesel LLC · Concord, NCN8460PLadet William D · Las Vegas, NVN8465PHorton Charles S Jr · Diamondhead, MSN8466PBrindeiro Stephen M · Artesia, NMN8468PLucy Douglas S · Apple Valley, CAN8468YStone D L · Arlington, TXN846PAfonso Joseph · Wallkill, NYN8474PCopass Benjamin J · Fountain Run, KYN8475PBlackdog Air LLC · Wilmington, DEN8475YSolymossy Robert A · Tysons, VAN8477PD F Osborne Construction Inc · Topeka, KSN847BRegistration Inc · Kalispell, MTN847EDFoster Matthew R · Poplar Grove, ILN847SPRothschild Joel S · Crestline, CAN8480PGlaser Violet E · Calhan, CON8481PBailey Roger R · Mineral, TXN8482PHogan John Robert · Palm Beach Gardens, FLN8483PHigh Wing Aviation LLC · Sardis, MSN8486PHaawq Air LLC · Brookshire, TXN8486ZKlompstra John V · Wadsworth, OHN8487YAviation Safety Dynamics LLC · Richmond, TXN8489YSorbi Aviation Inc · El Cajon, CAN8491PHansen Jed D · Clark, SDN8492YGaipa Timothy A · Saint Joseph, MIN8493PKeystone Flyer LLC · Avon, INN8496YOsiol Russell E · Chicago, ILN8497PCrotts Leigh O · Peoria, AZN8498PMiller Marc D Trustee · Tempe, AZN84JPNichols John E · Bogalusa, LAN84JSKocak Robert G Jr · Peoria, AZN84TDBailey Dennis · Kernersville, NCN84VKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN8503YRoberti John O · Barre, VTN8505YCli Aerospace LLC · Appleton, WIN8506YWilliams Russell D · Rehoboth Beach, DEN8507YWhiteley Robert L · Pittsburg, CAN8509PWalsh Robert A · Katy, TX
Back to AD 77-13-21