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.
N6688RFarley Clayton · Hanford, CAN6688WArkansas Air Expeditions And Instruction LLC · Greenbrier, ARN66898Registration Pending · Haines, AKRegistration pendingN6689PQuintero Noel · Fontana, CAN6689UStillman Troy C · Neenah, WIN6689WStoll Jared M · Burnt Hills, NYN668BNBelter Randolph K · Zachary, LAN668CWPrecision Air Inc · Anchorage, AKN668GWRholetter Wayne C · Westminster, SCN668LStarr Larry D · Gold Hill, NCN668MAJohnson Saquane · Sunderland, MDN668QUnruly Passengers LLC · Piedmont, SCN668RFSass Roland Falk · Beale Afb, CAN668RVForester James C · Trenton, GAN668SANorth Country Heli-Flight Inc · Wilmington, DEN668TMAlpha Helicopters LLC · Lewes, DEN66908Herman Timothy R · Presho, SDN6690DMiesko Martin A · Sprng Brk Twp, PAN6690JJones Michael A · Chateaugay, NYN6691LCoconut Adventures LLC · Lewes, DEN6691RSgt Land And Cattle Co LLC · Bennington, KSN6691USchleis Ralph F · Manitowoc, WIN6691WN6691w LLC · Nazareth, PAN6692ZCavanaugh Flying Service Inc · Minden, NEN6693HSwithenbank Leonard Co-Trustee · Fort Bragg, CAN6693JOgrady Thomas · Franklin Square, NYN6693UShapiro Kier I · Oxnard, CAN6694EThunderbird Aviation LLC · Littleton, CON6694JStegemoller Adam Dean · Lewisville, TXN6694RRegistered aircraftN6694UWilson Larry · Campbellsville, KYN6694WKhan Mohammed Sabir K · Sugar Land, TXN6695JMorgan Jonathan · East Troy, WIN6695MRegistration Pending · Sheridan, WYRegistration pendingN6695RKepner Charles M · Shepherd, MIN6695WMeyers Chris · Andrews, TXN6696JTattersall Stewart Trustee · Minden, NVN6696UAtkinson Matthew D · Theodore, ALN6697DAtlanta Aviation Academy Inc · Lawrenceville, GAN6697JGlenn Larry W · Bunn, NCN6697PTri County Air Courier LLC · Prosper, TXN6697RJ Bar Ranch LLC · Downey, IDN6698HNational Test Pilot School · Mojave, CAN6698QBrager Robert L · Oxnard, CAN6698VHeberlein Ronald E · Wilsonville, ORN6699Jcmc Inc · Junction City, KSN6699JRegistration Pending · Loup City, NERegistration pendingN6699LPierce Jeffrey D · Woodinville, WAN6699SBeach Coleen W · Moncks Corner, SCN6699UGuy Carlo A · Ramona, CA
Back to AD 87-10-06 R1