AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N6500PDennison Ronald Walton Trustee · San Jose, CAN6500UWhitson Mark A · Houston, TXN6501Ramirez Ricardo M · Camano Island, WAN6501CGcbc LLC · Norman, OKN6501JAndersen Aviation LLC · Leavenworth, WAN6501RAbove Earth Aerospace LLC · Friendswood, TXN6501WStewarts Aircraft Service Inc · Waynesville, OHN6502Keen Brandon M · Brunswick, MEN65021Borda Anthony J · West Chester, PAN6502JGanuza Diego J · Okeechobee, FLN6502PMelvin Kelly G · Green River, WYN6502RSmith Duane · Felt, OKN6502WMid American Pilot Association Inc · Lawrenceville, ILN6503BSmith Gregory E · Manila, ARFirst renewal noticeN6503DManubay John M · Sinking Spring, PAN6503HBrafford John Lee · Kings Mountain, NCN6503JTischler Keith Louris · Round Rock, TXN6503MCentral Texas College · Killeen, TXN6503UMooney 6503u LLC · Naples, FLN6503VSt Cloud Technical & Community College · Saint Cloud, MNN65045Twin City Cloud 7 Inc · Eden Prairie, MNN65048Bartlett Robert E · Cleveland, TXN6504CBraddy James R Jr · Sunnyvale, TXN6504RJohn M Peters · Damascus, MDN6504SNurmi Forrest Cal · Burlington, WAN6504VYoung Charles Wade · Rogers, ARN6504YLiebig Bryan H · Sacramento, CAN65057Good Winds LLC · Waterville, MEN65058Organization Of Black Aerospace Professionals Inc · Westchester, ILN6505HDe Creeft Joseph M · Homer, AKN6505JWedel Dan P · Fairmont, MNN6505MUrrea Hugo Edmundo Rincon · Katy, TXN6505PCaduda & Faulk Aero Ltd · Nederland, CON6505UBell Keith O · Navarre, FLN6505WOndracek Jack E · Port Orchard, WAN65061Tennis Gayland L · Bath, MIN65065Angel Aviation Inc · Peoria, AZN6506AFallon Timothy R · Ithaca, NYN6506DWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTN6506ULambert Isabelle O · El Paso, TXN6506WRoehrig Michael A · Fairport, NYN65072Jezebel Doghouse LLC · Kalispell, MTN6507CBollum Justin Keith · Chevy Chase, MDN6507JBarnes Brandon M · Metamora, ILN6507RJoachim Peter · Grafton, WIN6507UBovey Dominic C · Sandpoint, IDN6508HBkb Inc · Newport, MIN6508KTroy Oakland Pilots Flying Club Inc · Troy, MIN6508RSterling Creek LLC · Brookings, SDN6509CFrazier Aviation LLC · Ontario, OR
Back to AD 81-18-04 R2