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.
N737ZGDuck Air LLC · Mooresville, NCN737ZJLazy Eights Holdings LLC · Greenwood, INN737ZKAk Fly Inc · Kasilof, AKN737ZNEquinoxx Flight Systems LLC · Lawrenceville, GAN737ZPJahawk Leasing LLC · Sugar Grove, ILN737ZRTennessee Seaplane Company LLC · Knoxville, TNN737ZTEdwards Ronald R · Clinton, ARN737ZVJax Aero LLC · Jacksonville, FLN737ZWS & S Aviation Co · Ball Ground, GAN737ZZRandick George A · Birch Run, MIN73800Soul Aviation LLC · Newport Beach, CAN73808Delta Aviation Inc · Monticello, MNN7380DKirby Robert H · Hallsville, TXN7380GOrlandi Properties LLC · Blairstown, NJN7380JBednarek Michael H · Centerville, OHN7380RLewis University · Romeoville, ILN7380WRohlfes David M · Newcastle, CAN73813Smoot Russell L · Louisville, KYN73816Nedved Aviation LLC · Mitchell, SDN73819Botter Marlene S Trustee · Kent, WAN7381PPax River Flyers LLC · Kennett Square, PAN7381SSeitz Anthony Wayne · Heppner, ORN7381WTogliatti Robert A · Lakewood, OHN7382DSchneider Aerial Inc · Rugby, NDN7382JMinor Air LLC · Joplin, MON7382PAir Jav Aviation · Paso Robles, CAN73830Asbury Paul G · Charleston, TNN73837Bloomex Aviation LLC · Montvale, NJN7383JCox Jakori Akeem · Las Vegas, NVN7383WRed Rock Flying School LLC · Mesa, AZN7383XMcdonald Michael R · Sunnyvale, CAN73846Bernstein Matthew D · North Charleston, SCN73848Dorson Daniel J · Eden Prairie, MNN7384DSteinbrecher Kevin · North Pole, AKN7384EFierman Jo Angela · Madison, GAN7384WRader Kyle L · Hutto, TXN7384YMccafferty Robert S · Duluth, GAN73852Carrion Jesus · Staten Island, NYN73855Dury Aviation Services Inc · Portage Des Sioux, MON7385JGardner Chuck R · Estherville, IAN7385PAbughazaleh Ziad · Altadena, CAN73864Martz Richard W · Alta Loma, CAN73868Ca Aero LLC · Fairfield, NJN7386GCrosswind Flyers Inc · Newton, NJN7386KAffiliated Equipment Leasing LLC · New Castle, DEN7386YAlbee Philip · Cameron Park, CAN7387DTodd Doug G · Brainerd, MNN7387EKiefhaber Thomas R · Cincinnati, OHN7387GSale Reported · Redondo Beach, CASale reportedN7387YLillquist Brien I · Oak Harbor, WA
Back to AD 87-10-06 R1