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.
N61RFDumont Franck M · Chippewa Falls, WIN61RMMckenna Michael B · Lawrenceville, GAN61RRAap Holdings LLC · Montana City, MTN61RVSharpe David F · Ocala, FLN61SEBase III LLC · Winnetka, ILN61TACti Aircraft Leasing LLC · Memphis, TNN61TDCrick Christopher J · Guthrie, OKN61TMElliott Randy K · Wasilla, AKN61USLakes Aviation LLC · Lakewood, ILN61VAChristensen Rand V Trustee · Encinitas, CAN61VLKamiab Kambiz · Bonners Ferry, IDN61XBBickham John G · Los Lunas, NMN61ZBIntegratis Inc · Carmel, CAN6200DLundgren Mark C · Philipsburg, MTN6200RFlycarolina LLC · Charlotte, NCN6200UWhatley Equipment Co Inc · Van, TXN6200WGraves Jeffrey D · Smithville, TXN6200ZAerial Banners Inc · Pembroke Pines, FLN6201APhenix Transportation LLC · Sheridan, WYN6201FJohnson Norman E · Ellijay, GAN6201JL7 Aviation LLC · Geary, OKN6201MJordan Stephen · Bend, ORN6201PBrady James W · Moncure, NCFirst renewal noticeN6201WWilliam James S · Central City, NEN6201YSorenson Andrew · Pickens, SCN6202PCollins Owen Stewart · Toccoa, GAN6202UHolmes Richard · Provo, UTN6202XBlue Sky Aviation Service LLC · Sioux Falls, SDN62032Bayer Brandon · Dayton, OHN62033Mccain Robert E · Wasilla, AKN6203JJackman William Lee · Newman Lake, WAN6203KDeleon-Muniz Mario Antonio · Hemet, CAN6203PClark Jason H · Ridgecrest, CAN6203WCoastal Valley Aviation Inc · Santa Maria, CAN6203ZKnutson Wayne R · Tioga, NDN6204JFotos Kenneth J · Spring Grove, ILN6204WTownley Bryan W · North Bend, WAN62052Bolinger Ray G · Kuna, IDN6205JWisconsin Aviation-Four Lakes Inc · Madison, WIN6205PTwo Dot Aircraft Ll · Kalispell, MTN6205TOglesby Dale A · Galena, KSN6205UAdams Claude T Jr · Palmer, AKN6205VRed Baron LLC · Middletown, DEN6205WDave'S Aircraft Inc · Edgewater, FLN6205YMarschke Corey A · Stevens Point, WIN6206DP & W Investments Inc · Wilmington, DEFirst renewal noticeN6206JMerino Cesar · Washington, DCN62072Lytwyn Marcian · West Chesterfield, NHN6207PSquawk 2310 LLC · Ridgefield, WAN6207ULatimer Mark A · Roanoke, TX
Back to AD 87-10-06 R1