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.
N675QFisher Global LLC · Conway, ARN675RFGoodson Danny R · Bristol, VAN6760BAnderson Michael N · Anchorage, AKN6760WBitter Loren Mark · Maricopa, AZN6761UJaeger Howard E · Claremore, OKN6761WGirdley James Kevin · Taylorsville, KYN6762BCarver Clarence K Trustee · Lutz, FLN6762LSummit Aviation LLC · Sun Valley, IDN6762NTaylor Norman A · Fayette, ALN6762WFox John M · Warrenville, ILN6763JMiddlestetter Matthew G · Green Cove Springs, FLN6763NRegistration Pending · Minden, NVRegistration pending, pending cancellationN6763PHeublein Eric C · Molalla, ORN6764BMccollum Glen R Jr · Nikiski, AKN6764JZalik Michael A · San Francisco, CAN6764NBiermann William W · Hollister, CAN6765NBogdan Joseph H · Soper, OKN6765PJamison Ronnie L · Phoenix, AZN6765WKakoczki Robert J · White Cloud, MIN6766BRutland Norman L Jr · Birmingham, ALN6766NFoley Erik J · Henderson, NVN6766PStephens Christopher R · Upper Marlboro, MDN6767BHolseberg Aviation LLC · Ridgeville, SCN6767CSilverstein Devyn · Austin, TXN6767JLarson Wayne K · Amboy, CAN6767NEichhorn Tyler L · Paonia, CON6767VParmenter Micah J · Aurora, CON6768BKimmel Frank Stewart III · Greenwood, MSN6768FFallis Robert P · Keller, TXN6768JSuncoast Flight Training LLC · Sarasota, FLN6768NPorthouse Chris · Bellingham, MAN6768PKeenan John E · Saratoga, CAN6768RTaylor Bradley K · Muskego, WIN6768UBranson Randel L · Eclectic, ALN6768WCimeira Aviation LLC · Birmingham, ALN6768YPiper Aircraft Inc · Vero Beach, FLN6769JHanson Tobin S · Westlake, ORN6769NCausey Kevin L · Bainbridge, GAN6769PKroll Richard L · Montague, MIN6769UWard Leonard · Preston, IDN676APiper Archer Three LLC · Wilmington, DEN676AKDillard Clayton B · Talkeetna, AKN676ARBlackdog Air LLC · Belton, SCN676CHTake Off Aviation Services LLC · Rockledge, FLN676DWSunrise Aviation Inc · Ormond Beach, FLN676ECCastle Joseph E · Marietta, OHN676FLEdwards William J · Big Rapids, MIN676MMButler Nathaniel J · West Fargo, NDN676NLoftus Timothy P · Mclean, VAN676QKeil Urban G · The Villages, FL
Back to AD 87-10-06 R1