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.
N65971Georgalos Aircraft LLC · Eagle Point, ORN6597GOff Airport Adventures LLC · Saint David, AZN6597UAldo Leonardi · Woodland, CAN6597VGold Air LLC · Woodland Hills, CAN65988Arkansas Industrial Manufacturing LLC · Wilmington, DEN6598JThatcher Bruce Lyall · Shorewood, MNN6598UAdams Michael S · Huntsville, ALN65991Crysler Douglas Michael · Rockford, MIN65994Christiansen Aviation LLC · Wilmington, DEN65995Phoenix Flyers Inc · Mesa, AZN6599DBlue Shield Aviation LLC · Saint Petersburg, FLN6599JCormack Matthew S · Chandler, AZN659APiper Archer Three LLC · Wilmington, DEN659DEEisenhauer Dwight · Lehighton, PAN659DMFtr Esc LLC · San Antonio, TXN659FLHudacko Daniel M · Saint Cloud, FLFirst renewal noticeN659FTFlorida Institute Of Technology Inc · Melbourne, FLN659GJHolmes Jonathan Charles · Mount Pleasant, SCN659HCHowlett Corey · Wasilla, AKN659KWWoods Kevin E · Albrightsville, PAN659SPChristiansen Aviation LLC · Wilmington, DEN659TLLubonovic Thomas M · New Carlisle, OHN65ATRhodes Steven D · Anchorage, AKN65BJRamage Calvin L · Columbia, MON65BMVolatilis LLC · Wilmington, DEN65CDTeva Services LLC · Land O Lakes, FLN65CMCapital City Jet Center Inc · Somerset, OHN65CNJohnston Charles Wc Jr · Newfield, NJN65CWFranks Cory · Idalou, TXN65DEKilpatrick Blake E · Canyon Lake, TXN65DFAerospace Trust Management LLC Trustee · Wilmington, DEN65DHCrocker John M · El Dorado, CAN65DMCorry Aviation LLC · Tequesta, FLN65DPPilawski Darren · Spring Hill, FLN65DRKlr Services LLC · Newalla, OKN65ECMartinez Fernando · Midland, TXN65EDConrad James J · Port Orange, FLN65EEEssler Kim L · Garrison, NDN65EJRobbins Lesley Linn · Bend, ORN65ESShaw Ellen M · Green Bay, WIN65EXInvert Aero LLC · Saint Augustine, FLN65FTSkytypers Inc · Las Vegas, NVN65FVVyfvinkel Frederick J · New Smyrna Beach, FLN65GSchmitt Joseph P · Marshall, MON65GLDavidson Amber M · Cocoa, FLN65GSCheyenne Air LLC · Charleston, WVN65HRSt Squared LLC · Powell Butte, ORN65HTRoberts Bryan J · Norman, OKN65HYMarchant William A · Cleveland, GAN65JAJahawk Leasing LLC · Sugar Grove, IL
Back to AD 87-10-06 R1