AD 68-07-08
Registered aircraft · 196
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:68-07-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:68-07-08')
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:68-07-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:68-07-08') 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.
N51456Saunders David E · Monticello, FLN51458North Idaho Crushing Inc · Moscow, IDN51460Sale Reported · Carriere, MSSale reported, pending cancellationN51463Kelly John Thomas III · Bells, TXN52TGBarbosa David J · Caribou, MEN540JCFedorko Daniel J · Saylorsburg, PAN56HBLopez Michael · North Pole, AKN615SDHolland Andrew K · Sterling, AKN6JNRinaldi Stephen J · Plymouth, CTN7602AAlbers Julie H · Burlington Flats, NYN86988Triple W Metal Building Construction LLC · Weatherford, TXN8880ABroadwell Eric · Woodstock, GAN8YPClear Blue Marketing Inc · Reno, NVN9237ZBugden Michael S · Newnan, GAN9243ACollins Carvel Key · Uvalde, TXFirst renewal noticeN92WVSilvey Lloyd R · Hale, MON9801MUnderwood Mack C · Aiken, SCN9802MBell Andrew J · Moultrie, GAN9803MJohnson Craig A · Moreland, GAN9804MHastie John L III · Bethel, AKN9808MGerling Matthew Karl · Eagle River, AKN9810MPakuer Levi R · Salmon, IDN9813MGagnebin Michael · Steamboat Springs, CON9816MShaw David H · Nenana, AKN9819MBurnett Scott L · Roswell, NMN9823MKoelsch Benjamin · Nome, AKN9826MBreitbach Perry J · Circle, MTN9830MChaney George M · Tellico Plains, TNN9831MPham Hieu T · Steilacoom, WAN9838MWaldor Asherjohn · Ford City, PAN9839MRegistered aircraftN9840MBlackstone Christopher M · Oregon City, ORN9841MMusser Alvin M Jr · Memphis, MON9845MRichardson Ronald W Trustee · Stewartville, MNN9846MSchrull Robert E · Brattleboro, VTN9849MAndersen Chris · Forest Grove, ORN9850MCopeland Tyler G · Prineville, ORN9855MNylund Michael K · Wasilla, AKN9858MUpton James · Guthrie, OKN9861MSouthern Aircraft Consultancy Inc Trustee · Casper, WYN9864MCizek Joseph E · Wasilla, AKN9865MLaing Thomas L · Aurora, CON9868MBeckwith Michael E · Kenai, AKN986RHebblewhite Arthur E · Waunakee, WIN9872MBatchelder James · Kenai, AKN9GMColman Scott Preston · Tampa, FL
Back to AD 68-07-08