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.
N9760UFitzgerald John P · Pittsburgh, PAN9760WRegistered aircraftN9761PBig Q Aviation Corporation · Helena, MTN9761WRivera-Osorio Karolina · Monroe, NYN9762DMarshall Marcus D · Georgetown, TXN9762PKnutson Wayne R · Thompson, NDFirst renewal noticeN9762QMazda Russell · Newark, DEN97632Henderson James L · Jackson, MSN9763HReed Grain & Bean Inc · Buhl, IDN9763JShaffer Timothy R · Marion, IAN9763MWaldren Paden · Garden Valley, CAN9764FFixed Wing Holding Co Inc · Pembroke Pines, FLN9764KSchoff Wardell R · Hamilton, MON9764MSilcott Robert W III · Fairview, OKN9764WMich John D · Fort Morgan, CON97650Updraft LLC · Kissimmee, FLN9765DPatey Daniel J · Lakewood, CAN9765JPinson Cassandra · Chandler, AZN9765LMartone Aviation LLC · Ocala, FLN9765MMahoney James P · Renton, WAN9765WShelby Gary J · Harleysville, PAN97662Northwest Alabama Holdings LLC · Spruce Pine, ALN9766DMayer Gregory B · Fall River Mills, CAN9766WYoung Justice P · Prairie Grove, ARN97674Oc Flight Lessons LLC · Costa Mesa, CAN9767JMatta Aviation Services LLC · Junction City, KSN9767MMcgill James D · Tucson, AZN9767PVanhorne Robert E · Centralia, ILN9767WBrighton Flying Club LLC · Brighton, MIN97681Buiqui Aerospace Corp · Kissimmee, FLN9768CHansen Kurt C · Washington, UTN9768JOpp Prop Air LLC · Collierville, TNN9768WEichner Cynthia A Loening · Tolland, CTN9769FFrost Aviation Services Inc · Las Cruces, NMN9769JDubovtsev Mikhail · Wildwood, NJN976ACNaples Air Center Inc · Naples, FLN976AZWl Aviation LLC · Boca Raton, FLN976BEAero Sphere Inc · Mcclellan, CAN976CAFlydreams Aircraft Group Inc · Fort Lauderdale, FLN976DPKnox John R · Arvada, CON976DRRed 6 Technologies LLC · Santa Monica, CAN976LSSmith Lawrence B · Clovis, CAN976MSStaten Joseph A · Kitty Hawk, NCN976PShahen Michael A III · Belleville, ILN976WBBuckland Lauren O Jr · Winder, GAN97702Smith Jeffrey W · Yakima, WAN9770UPlegge Timothy E · Granbury, TXN9770WRegistration Pending · Altus, OKRegistration pendingN9771DHull Christian M · Palmer, AKN9771JBuzzard Roost Aviation LLC · Marble, NC
Back to AD 87-10-06 R1