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.
N928BLWingsleasing LLC · Wichita, KSN928DSColey Thomas B · Westchester, ILN928EARegistered aircraftN928EFAon-Adharc Aircraft Leasing LLC · Sellersburg, INN928GTD Aumeries Baudouin G · Pagosa Springs, CON928HLJ & M Sales & Leasing LLC · Abingdon, ILN928HWSouthern Aircraft Consultancy Inc Trustee · Casper, WYN928LPMontana Freedom Riders LLC · Corvallis, MTN928LYLp Aviation Maintenance LLC · Bayonne, NJN928MAAnson Air LLC · Sugar Land, TXFirst renewal noticeN928MTMountain View Cabin LLC · Southlake, TXN928PBoyer Brian · Gilbert, AZN928PPSwair LLC · Denver, CON928TAPray Aviation Inc · Augusta, KSN928TGNorthward Bound LLC · Anchorage, AKN928WAChapman Martha P · Rogersville, TNN928WCMatthews Kyle · Dayton, OHN928WTMoxie Leasing LLC · Clarkdale, AZN92908C-140 Company LLC · Pensacola, FLN9290CMym Air LLC · Pattison, TXN9290DSymons George Jay Trustee · San Francisco, CAN9290JRodgers Bruce F · Quakertown, PAN9290KArrow Leaseback LLC · Danbury, CTN9290NFlight Vision 1 LLC · Lake Mary, FLN9290PSpartan Education LLC · Tulsa, OKN9290SRoss Executive Aviation Inc · Fort Smith, ARN9290UPiper Aircraft Inc · Vero Beach, FLN9291FHealey David A · Hammondsport, NYN9291HDawson William F Jr · Port Hueneme, CAN9291JMidwest Aero Club Inc · Omaha, NEN9291KNeff Brandon L · Emporia, KSN9291RBobo Richard H · Okolona, MSN9291VHutchens David R · Pikeville, KYN9291WFarleman LLC · Aurora, OHN9292HBlackhawk Flying Club Inc · Rockford, ILN9292LRegistered aircraftN9292MAkro N9292m LLC · Lighthouse Point, FLN9292NN9292n LLC · Valdosta, GAN9292PRegistered aircraftN9292QRegistered aircraftN9292YWeisend Chad M · Logansport, INN9292ZAbrams Perry · Palmer, AKN92934Service Oriented Aviation Readiness (Soar) · Bolivar, MON9293BCludy Skies LLC · Wildwood, MON9293JChaldu Ronald S · Oswego, NYN9293KYakel Donald L Jr · Springfield, ILFirst renewal noticeN9293PCenterline Holdings Inc · Camden, DEN9293YBecker Ryan · Sheldon, IAN92945Fla Inc · Wilmington, DEN92949Prouts Travel LLC · Wilmington, DE
Back to AD 87-10-06 R1