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.
N841JWScenic Concepts LLC · La Crosse, WIN841LSAnderson Paul N · Edmond, OKN841NDUnd Aerospace Foundation · Grand Forks, NDN841NHMarrs Matt · Bentonville, ARN841PGeeslin James W Jr · Sterling, AKN841PSLivin The Dream Aviation LLC · Jupiter, FLN841RSVintage Pursuits LLC · Crestwood, KYN841RVPotter Robin B · Southport, NCN841TMJet Aviation LLC · Commerce Township, MIN841WBQualitair LLC Trustee · MichelstadtN84205Mitchell Myron · Advance, NCN84209Arwood Ralph Trustee · Naples, FLN8420BSplash & Go Seaplanes LLC · Miami, FLN8420CRegistered aircraftN8420DAlsworth Glen R Sr · Port Alsworth, AKN8420JGimple Herman Wm · Greenville, CAN8420LHayhurst Shane R · Winfield, PAN8420RMueller Lance · Milton, DEN8420WMckee Shane D · Fairbanks, AKN8420YVanwarmerdam Leslie C · Nampa, IDN84210Pm Jets LLC · Ashland, OHN84214Planefully Obvious LLC · Oshkosh, WIN84219Manhattan Management Corp · Brooklyn, NYN8421AKing Air Inc · Naknek, AKN8421DPutman Bruce C · Leonard, MIN8421JRegistered aircraftN8421RRoberts Darren C · Zionsville, INN8421YKesser Gilbert M · Culpeper, VAN84221Mcknight Michael D · Marietta, GAN84224Cordes Jeffrey A · Happy Valley, ORN84225Executive Flight Institute LLC · Murrieta, CAN84226Jackson County Aviation LLC · Sneads, FLN84227Jernigan Alex E · Warrensburg, MON84229Langenbahn Theodore John · Schoharie, NYN8422HDeevers Howard A · Tucson, AZN8422LHubert Kim J Trustee · Eagle River, AKN8422MDymond Mark S · Monterey, TNN8422NCenter Flying Inc · Lancaster, CAN8422PAnderson William · Creve Coeur, ILN8422RTascarella William M · Quakertown, PAN8422W642 Flying Club Of Fort Worth Inc · Fort Worth, TXN84234Mazelg Aviation LLC · Bartow, FLN84235Klj Air LLC · Fairless Hills, PAN8423DKearney Rick G · Amity, PAN8423LYoung James A · Toledo, WAN8423PAdams Mark · Sumter, SCN8423WGillanders Kenneth William · Carson City, NVN8424Huston Charles D · Austin, TXN84243Sjoberg Donald E · Poteau, OKN8424ATringale Alison · Port Saint Joe, FL
Back to AD 87-10-06 R1