AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N658LMLge Flying Club Inc · Marietta, GAN658NDUniversity Of North Dakota · Grand Forks, NDN658NVJp Aero Holdings Inc · Carson City, NVN658RLVagim Jason P · Granbury, TXN658SEvalenko Robert A · Arlington, TNFirst renewal noticeN658SEChandelle LLC · Wilmington, DEN658SRJung Sue Elaine · Lawton, OKN658VCruiser Flying LLC · Pleasant View, UTN658XLMertz George H III · Reading, PAN65903N65903 LLC · Union Gap, WAN65904Electra Aviation LLC · Wilmington, DEN65908Sanders Thomas W · Overgaard, AZN65909Oldwater 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, NDN65912Lima Alfa LLC · Whitefish, MTN6591AHerk Aviation LLC · New Bern, NCN6591EWay Robert Louis · Morristown, AZN6591PRichardson Jeffrey S · Grove City, PAN6591VEpic Air Power LLC · Newark, DEN65920Hellroaring Technologies Inc · Polson, MTN65923Noste Erik · Mount Vernon, WAN65926Pc Aviation LLC · Kanarraville, UTN65927Garmin International Inc · Olathe, KSN6592JWorland Flying Club LLC · Worland, WYN6592LPruszenski Stanley F · Anchorage, AKN6592UEriksson Trent A · Waterford, MIN6592WChait Braeden Abraham · Vancouver, WAN65932Techflitewest LLC · Brookville, OHN65937Berendschot Leonardus · Huntsville, TXN6593AHard Luck Aviation LLC · Tok, AKN6593JRed Tail Scholarship Foundation · Tuskegee, ALN6593PAshenhurst Thane T · Wheatland, WYN6593RZwicker Brian · Richmond Hill, GAN6594FTabbert William · Diamondhead, MSN6594JHub 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, WAN65966Registered aircraftN6596DMcdonald Kevin K · Anchorage, AKN6596ULipper Charles S Pers Rep · Stone Mountain, GAFirst renewal noticeN6596WN6596w LLC · Derby, KSN6596XRingen Marvin O · Beaverton, OR
Back to AD 87-10-06 R1