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.
N70SUOhio State University · Columbus, OHN70SXMenear Elwood F · Hummelstown, PAFirst renewal noticeN70TPhillips Fire Design LLC · Colorado Springs, CON70TASixty Three Charlie Zulu Inc · Thonotosassa, FLN70TLAltitude Adjusters LLC · Cranford, NJN70VBPalmy LLC · Lander, WYN70WSKappel Fred G · Memphis, TNFirst renewal noticeN70WTLoboschefsky Terry · Park City, UTN70XPHolbrook Dennis · Woodbridge, CAN7100Registered aircraftN7100EStrickler Elizabeth D · Ringgold, TXN7100FRegistered aircraftN7100GBoyd John J · Wasilla, AKN7100UTeerlink Randall Spencer · Hanover, VAN7100WKlein Jarmes Harold · Lino Lakes, MNN7101GBowhawk LLC · Ocala, FLN7101UJucha Raymond A · Mount Dora, FLN7101VEquus All American LLC · Midwest City, OKN7101WDobson Michael E · Columbus, OHN7101YN7101y LLC · Wilmington, DEN7102GBarbosa Manuel · Apple Valley, MNN7102LWestergard Matthew J · Fort Mill, SCN7102PTurner Lake Aviation LLC · Sioux Falls, SDN7102QJuckett Jimmy L · Springhill, LAN7102WHower Nicholas J · Centerville, OHN7102ZRegistered aircraftN7103GMountain Flyers Inc · Hendersonville, NCN7103PRiegel Robert L · South Pasadena, CAN7103VLennartson Gerald J · Greensboro, NCN7103WDunavin Joseph E · Menasha, WIN7104FPotrafka Richard M · Rolla, MON7104GAir Carriage LLC · Chico, CAN7104PHill Chester · Bakersfield, CAN7104VPorzillo Patrick H · Newburg, MDN7104WRegistration Pending · Shelbyville, TNRegistration pendingN7105LTolbert John M · Jacksonville Beach, FLN7105PPruet Glen A · Richardson, TXN7105UMolter Roy G · Shelbyville, INN7105VCromwell James T · Hamilton, MTN7105WDeibert Dale A · Herreid, SDN7106BSlaughter D Wayne · Farmsville, NCN7106DHarris & Associates Inc · Scottsdale, AZN7106UTappon Wayne A · Ladysmith, WIN7106VMcatee Von · Houston, TXN7106WGriffin Jim T · Tunnel Hill, GAN7107LYellowjet Flying Club LLC · Mukilteo, WAN7107UJohnson Kenneth D · Camdenton, MON7107WCaufield Dennis R · Carl Junction, MON7108DWestern Antique Aeroplane & Automobile Museum · Hood River, ORN7108GLakes Area Aviation LLC · Little Falls, MN
Back to AD 87-10-06 R1