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.
N68XLsk Aviation Corp · Wilmington, DEN69007Jj Kramer Aviation LLC · Vero Beach, FLN6900DMahoney Shane · Auburn, WAN6900JCaruso Jerry W Jr · Kingsbury, NYN6900NBond William E · Elk River, MNN6900PMyer Charles G · Forest Lake, MNN6900TAircraft Guaranty Corp Trustee · Oklahoma City, OKN6900URegistered aircraftN6900WHall William Brent · Tulia, TXN6900ZIndependence Glider Club · Independence, ORN6901ASpence Stephen L · Anchorage, AKN6901HRieser Steven E II · Baltimore, OHN6901NRagsdale James W · Geneva, FLN6901QCbus Flight LLC · Pickerington, OHN6901ULime Lounge LLC · Des Moines, IAN6902DFerrell Alan B · Arlington, OHN6902NSherrill Charles H · Robert Lee, TXN6902YJ L Darr & Son Inc · High Point, NCN6903BJones Gary L · Kerrville, TXN6903JGreen Valley Aerospace LLC · Lexington, VAN6903NRoland Jason R · Royse City, TXN6903PStack Gregory R · Aurora, CON6903QSullivan Lynford M · Hernando, MSN6903RFusion Marine Inc · Stuart, FLN6903UPray Aviation Inc · Augusta, KSN6904ALesser Antilles Corp Trustee · Wilmington, DEN6904DLucas Michael F · Germantown, OHN6904NSchaffhauser Daniel L · Garland, TXN6904UMyers Ronnie L DBA · Appling, GAN6904YUnited Jet Sales Inc · Newark, DEN6905DEvans Theresa K · Alexandria, MNN6905HTang Flyer LLC · Wausau, WIN6905JDouble Delta Sierra LLC · Bristol, CTN6905NZero Five November Holding Inc · Kalispell, MTN6905PMampel Gregory J · New Port Richey, FLN6905VOscar Mike Appraisal Group LLC · Greenville, SCN6905WPodeweltz Wayne L · Merrill, WIN6905ZZellers And Smith Enterprises LLC · Flowood, MSN6906JBas Part Sales LLC · Greeley, CON6906PKapeller James A · Wickenburg, AZFirst renewal noticeN6906QFlorida Keys Flight Academy LLC · Marathon, FLN6906VMatthews Cheryl L · Baker City, ORN6906WStandard American Adjusters Inc · Alba, TXN6907BJordan Walter B · Chehalis, WAN6907JFisher Bradley J · Bryant, INN6907NHensley Tyler · Leland, NCN6907PHolbein Mark A · Freeport, PAN6907VPounds Gregory S · Sykesville, MDN6908BMeriden Aviation Center LLC · Meriden, CTN6908KRegistration Pending · Dillingham, AKRegistration pending
Back to AD 87-10-06 R1