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.
N8288FAtwood Jason P · La Porte, INN8288JRegistration Pending · Oklahoma City, OKRegistration pendingN8288LFrenzel Aviation Investments LLC · Brentwood, TNN8288PStelter John · Clancy, MTN8288ZPabon Hugo · Granada Hills, CAN8289AAircraft Guaranty Corp Trustee · Oklahoma City, OKN8289JCummings Steven R · League City, TXN8289XSheitelman Mitchell · Warren, NJN828AKOld City Helicopter Sales LLC · Saint Augustine, FLN828BCFitzdam Justin D · Franklin, TNN828BDEchols Mill Aviation LLC · Elberton, GAN828BLHartt Greg M · Fairfield, CAN828BMChristiansen Aviation LLC · Wilmington, DEN828BNTravelaire Service Inc · Pueblo, CON828CBStokes Robert J Jr · Queen Creek, AZN828CPCivil Air Patrol · Maxwell Afb, ALN828CRRegistration Pending · East Greenwich, RIRegistration pendingN828EJWhirld Helicopters Inc · Sevierville, TNN828FSPerformance Aircraft Sales Inc · Lincoln, NEN828HJPegasus Air Charter LLC · Hartford, CTN828JMJr Aviation LLC · Tulsa, OKN828JPCarney William F · Gallatin, TNN828KTJones Larry · Anchorage, AKN828LBBeraut Olivier Trustee · Scotts Valley, CAN828LPFlying Twenties Inc · San Jose, CAN828LSKelly Ryan · New York, NYN828LUMuldrow Erik · Newport, KYN828MCHub City Aviation Academy LLC · Lubbock, TXN828PDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN828PLGrosso Michael F · Charleston, SCN828RDCedar Ridge Aviation LLC · Knox City, TXN828RVNewman Charles W · Petaluma, CAN828RWStankie Alexander M · Cocoa Beach, FLN828SPVista Aviation Inc · Pacoima, CAN828SRGulfcoast Aviation Inc · Wilmington, DEN828TSPlane Fun Inc Tr Trustee · Snellville, GAN828YLong Island Aviators LLC · Seaford, NYN82905Reese Melissa A · Soldotna, AKN82907Law Offices Of David Henderson · Anchorage, AKN82908Hall Charles R · Leawood, KSN8290HSchildberg Gregory · Casey, IAN8290JSchaaf Rodney B · Bowman, NDN8290NHorne Larry E · Suffolk, VAN8290PEmge Douglas W · Albertville, ALN8290SNewsome Jeff · Blackwell, OKN8290WCastles James D · Portland, ORN8290XMorrison Preston L · Findlay, OHN82910Great Bay Air LLC · North Hampton, NHN82912Barrows Stuart L · Eagle River, AKN82918Herman Brant · Fairbanks, AK
Back to AD 87-10-06 R1