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.
N80472Simons George Trustee · Bouse, AZN80475Texas Southern University · Houston, TXN80476Sky Roamers LLC · Columbus, NEN8047DMurphy Robert · Kent, WAN8047LHolmes Frank L · Enterprise, ALN8047SRisso Christopher W · Huntington Beach, CAN8047WFlying Fossil LLC · Franklin, TNN80483Harrell Matthew J · Grand Haven, MIN80484Mor Aviation 172m LLC · Gaithersburg, MDN80486Romoser Carey E · Simpsonville, SCN80487Williams Fredrick Glen · Auburn, ALN80489P & K Aviation LLC · Neshkoro, WIN8048CDegraff Claude Md · Fort Myers, FLN8048DBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCN8048PCoastal Virginia Aviation LLC · Chesapeake, VAN80490American Patrols Inc · Midland, TXN80491Duffys Aircraft Sales & Leasing Inc · Neillsville, WIN80495Space Coast Aero LLC · Melbourne, FLN80496Bickel Gregory A · Mckinleyville, CAN80497Ducksrus LLC · Indianapolis, INN8049DFerrell Alan B · Arlington, OHN8049NKolbjornsen Arne · Middletown, DEN8049PFranklin Ricky L · Glade Hill, VAN8049WTennis Gayland L · Bath, MIN804ATFlight School Of Texas LLC · Wilmington, DEN804BD G Leasing LLC · Houston, TXN804BLFlores Omar Javier · New Braunfels, TXN804ERDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYN804GASaber Safa · Newburyport, MAN804JSButler Jack L · Bennington, OKN804LGDem Ventures LLC · Wichita, KSN804NVMoody Bible Institute Of Chicago · Spokane, WAN804QMay Richard U · Soquel, CAN804SMVogt Gregory A · Broken Arrow, OKN804VGLewis David S · Port Saint Lucie, FLN80507High Flight Academy LLC · Allison Park, PAN8050DSalerno Joseph C Jr · Gettysburg, PAFirst renewal noticeN8050EPerun Av LLC · Cliffside Park, NJN8050JParamus Flying Club Inc · Fairfield, NJN8050YGmm Records · Big Pine Key, FLN80511American Patrols Inc · Midland, TXN80517Powers Tia Nichole · Griffin, GAN80519Donald Ben B II · Carthage, TXN8051BBryant James T Jr · Pryor, OKN8051NSapienza Gregory T · Williamstown, NJN8051PReeder Blake · Amarillo, TXN8051VAv8 Flight Assets LLC · Eden Prairie, MNN8051WMcginn Gary P · Elk City, OKN80522Mikhael Hanna M · Livonia, MIN80525Dunkin Aviation LLC · Hensley, AR
Back to AD 87-10-06 R1