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.
N652RVKracmer Thomas J · Fort Myers, FLN652SPChristiansen Aviation LLC · Wilmington, DEN652SRBracy Rodney E · Middleville, MIN65306Bullet Power Brokers Inc · Stuart, FLN65309Satoyama Molokai LLC · Kaunakaka Molokia, HIN6530HWagons West LLC · Myrtle Beach, SCN6530JSalmon Woody W · Chalkyitsik, AKN6530RByers Travis M · Villa Rica, GAN6530UHeidelberg Haley · Huntington, TXN6530ZElk Mountain Soaring LLC · Bountiful, UTN6531CDorr Juergen W · Mundelein, ILN6531JLoehrer Daniel J · Milbank, SDN6531RBruno Gennaro S · Lewes, DEN6531YSmith Henry C III · Essexville, MIN65324Bickerstaff Mike · Port Orange, FLN65328Lingyun LLC · Winter Garden, FLN6532CQuartarolo Pete · Santa Rosa, CAN6532FCouch Walter Jack · Patterson, LAN6532JGarner Aviation LLC · Tampa, FLN6532PCarlsson Carl J · Mason City, IAN65339Shaw Andrew G · Huntingdon, PAN6533JPaulson James L · Lawrenceville, NJN6533LNorthcutt Cecil W III · Ponder, TXN6533PRegistered aircraftN6533W21 Luna LLC · Phoenix, AZN65348Anselmetti Federico · South Miami, FLN6534BMurphy Timothy · Lake City, FLN6534PNorwood Comanche Flyers LLC · Quincy, MAN6534UHuertas Andrew · Van Nuys, CAN65358Peanut Productions LLC · Sheridan, WYN6535GBbjs Investments LLC · Burlington, WIN6535HAerial Sign North Inc · Lakewood, NJN6535PPetter Kristopher · Orient, IAN6535TDobson Richard W · Phenix City, ALN65367Wheels Up Re LLC · Odenville, ALN6536JCooper David M · Sedona, AZN6536VTran Dai A · Rancho Cucamonga, CAN6536WDenny David F · Bath, NCN6537AYellow Jacket Aero LLC · Plymouth, MNN6537DCunningham Edward A · Washington, DCN6537FWheels Up Aviation LLC · Pittsburgh, PAN6537HRivers Robert A · Oxford, NCN6537JTimer Anna Mae · Wildwood Crest, NJN6538FMbk Leasing And Consulting LLC · Lakeland, FLN6538JBerra Robert J · Burtonsville, MDN6538PStorck Andrew D · Dayton, OHN6538RFunnell John R · Cedar Park, TXN6538VSommer Timothy T · Combined Locks, WIN6538WVenture Flying LLC · Mobile, ALN6539HAbove The Haze LLC · San Lorenzo, CA
Back to AD 87-10-06 R1