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.
N658VCruiser Flying LLC · Pleasant View, UTN658XLMertz George H III · Reading, PAN65903N65903 LLC · Union Gap, WAN65904Electra Aviation LLC · Wilmington, DEN65909Oldwater Trailers Inc · Wilmington, DEN6590AJ Robert Finley And Associates Inc · Mountain Home, ARN6590JRegistration Pending · Rathdrum, IDRegistration pendingN6590PClyde Damon S · Boulder City, NVN6590USanchez John D · Columbiaville, MIN6590ZKnutson Wayne R · Thompson, NDN6591AHerk Aviation LLC · New Bern, NCN6591EWay Robert Louis · Morristown, AZN6591PRichardson Jeffrey S · Grove City, PAN65923Noste Erik · Mount Vernon, WAN6592JWorland Flying Club LLC · Worland, WYN6592LPruszenski Stanley F · Anchorage, AKN6592QCd Aircraft LLC · Signal Hill, CAN6592UEriksson Trent A · Waterford, MIN6592WChait Braeden Abraham · Vancouver, WAN65937Berendschot Leonardus · Huntsville, TXN6593AHard Luck Aviation LLC · Tok, AKN6593JRed Tail Scholarship Foundation · Tuskegee, ALN6593PAshenhurst Thane T · Wheatland, WYN6593RZwicker Brian · Richmond Hill, GAN65940Bavarian Barnstormers 2 Inc · North Fort Myers, FLNon-citizen corporation, flight hours not reportedN6594JHub City Aviation Academy LLC · Lubbock, TXN6594PBoyd Larry C · Wellton, AZN6594RBig Bend Community College · Moses Lake, WAN65957Skybourne LLC · Stuart, VAN6595G95 Golf Inc · Greenwood, INN6595KMr B Aviation LLC · Sag Harbor, NYN6595RBig Bend Community College · Moses Lake, WAN65965Legends Air Center LLC · Bentonville, ARN65966Registered aircraftN6596DMcdonald Kevin K · Anchorage, AKN6596PAce Aircraft Leasing Inc · Nazareth, PAN6596ULipper Charles S Pers Rep · Stone Mountain, GAFirst renewal noticeN6596WN6596w LLC · Derby, KSN6596XRingen Marvin O · Beaverton, ORN6597GOff Airport Adventures LLC · Saint David, AZN6597UAldo Leonardi · Woodland, CAN65988Arkansas Industrial Manufacturing LLC · Wilmington, DEN6598JThatcher Bruce Lyall · Shorewood, MNN6598UAdams Michael S · Huntsville, ALN65991Crysler Douglas Michael · Rockford, MIN65994Christiansen Aviation LLC · Wilmington, DEN65995Phoenix Flyers Inc · Mesa, AZN6599DBlue Shield Aviation LLC · Saint Petersburg, FLN6599JCormack Matthew S · Chandler, AZN659APiper Archer Three LLC · Wilmington, DE
Back to AD 81-18-04 R2