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.
N6553DLlv Aviation LLC · Wilmington, DEN6553EZa Airport Rental LLC · Zanesville, OHN6553FArcwin Aero LLC · New Palestine, INN6553JCrestwater Properties LLC · Florence, SCN6553KSchaffner Christopher · Dunmore, WVN6553RRenkenberger Paul H · Yucaipa, CAN6553ULewis Orville W II · Memphis, TNN6554CCharles City Aeronautics Inc · Charles City, IAN6554DHancock Jeffrey D · Delta, CON6554WTpc Air LLC · Colleyville, TXN65557Classic Aircraft LLC · South Bend, INN6555JTeton Leasing LLC · Pocatello, IDN6555PBig Wings Inc · Delavan, MNN6555WDeeter George E · Chillicothe, OHN65567Skylane Sky LLC · North Palm Beach, FLN6556BLewis Joseph M · Huntington Beach, CAFirst renewal noticeN6556HRyco LLC · Lusk, WYN6556JJabco Inc · Weston, IDN6556UQoc Innovations LLC · Fall River, WIN6556VGiannola Peter S · San Diego, CAN6556WMontagnino James A · Saratoga Springs, NYN6557HRiverside Flight Academy LLC · Riverside, CAN6557JAsd LLC · Lebanon, NJN6557PBs Airlines LLC · Wahpeton, NDN6557UAtalla Mark S · Woodford, VAN6557WFrederick Darin L · Star, IDN65587Wings Over Texas Holdings LLC · Denton, TXN6558EZata Group LLC · North Little Rock, ARN6558JKarr Dennis R · Clyde, OHN6558UReed Gina D · Starkville, MSN6558WShirley Hills Aviation LLC · Macon, GAN6559PFitzpatrick Derek J · Murrieta, CAN6559WHarrison Michael W DBA · Lewisville, IDN655ACAuxier David R · Baker City, ORN655AGSkywest Leasing Inc · St George, UTN655CPCivil Air Patrol · Maxwell Afb, ALN655DKSkovbjerg Jorgen · Angwin, CAN655MAFanning John F · Delaware, OHN655NPPanasenko Nicholas · Machesney Park, ILN655PAWahleithner James K · Sacramento, CAN655PDJls Aviation LLC · Sarasota, FLN655RVMartin David M · Port Saint Lucie, FLN655SMcclellan George M · Salem, ORN655SKMassey Roger L Trustee · Nipomo, CAN655XRoyall Michael B · Morgan, UTN65602Ballew James H · Las Vegas, NVN6560RBurgett William J · Juneau, AKN6560UTeaford Kris K · Berryville, VAN6560WBeaunaux John-Daniel S · Graham, WAN6560ZPiper Aviation Museum Foundation · Lock Haven, PA
Back to AD 87-10-06 R1