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.
N6915VReindollar William Paul Jr · Derwood, MDN6915WOso Air LLC · Missoula, MTN69165Locaero Services Inc Trustee · Wilmington, DEN6916HFms Air LLC · Leesville, LAN6916KBrown Daniel A · Gettysburg, PAN6916NGray Wesley K · Sandia, TXN6916QShawn James R · Pattison, TXN6916YDk1 Aviation LLC · Fayetteville, NCN6917APiper Aircraft Inc · Vero Beach, FLN6917DOlds Forge Flyers Inc · Lansing, MIN6917GMarvell Aviation LLC · Marvell, ARN6917NBonak Steven · Punta Gorda, FLN6917VCamper Daniel P II · Port Angeles, WAN6917WCloutier Michael C · Waddell, AZN6918DTucker Christopher W · Johnstown, CON6918HWright Flight Inc · Tucson, AZN6918NBas Part Sales LLC · Greeley, CON6918WTopping Warren J · Sagaponack, NYN6919BPolyclinics.Net LLC · Hixson, TNN6919HTimmester Terry W · Little River, SCN6919JFlying Is Fun LLC · Atlanta, GAN6919MWest Byron Chad · Blue Grass, IAN6919NNicholas Dagmar H · Uniontown, OHN6919PMunroe Consulting · Ocala, FLN6919VKimzey Robert R · Cypress, TXN6919WN6919w LLC · Key West, FLN691BARotor Ops 269 LLC · Wilmington, DEN691BEWester Joshua · Emmett, IDN691DLJohnson Boyd D · Preston, IDN691DSNelson Travis K · Hamilton, MTN691FLKelley Keith B · Forney, TXN691KWHoegg Thomas K · Mountain Home, IDN691LHChristiansen Aviation LLC · Wilmington, DEN691MAMitchell Martin · Alpine, CAN691RPRegistration Pending · Mount Holly, VTRegistration pending, canceledN691SCSouthern Cross Aircraft LLC · Fort Lauderdale, FLN691SPGc Aviation Services-1 LLC · Miamisburg, OHN691TCSpartan National Holdings LLC · Missoula, MTN691WEagle Simulator LLC · Lake Oswego, ORN6920CKiesel James L · Hanford, CAN6920GValley Boys LLC · Lakeville, MNN6920NHodgman Gary W · Greenville, TXN6920PStanley Travis Navar · Dundee, OHN6920QNeff Marcus J · Tigard, ORN6920VPjs Enterprises · Havre, MTN69211Nelson John · Lusby, MDN6921BKnepp Gerald L · Milroy, INN6921NBower Edwin M · Norco, CAN6921PNormark Ronald L · Weirsdale, FLN6921VLebow Kirk · Clovis, NM
Back to AD 87-10-06 R1